Instead of filling out excel files with all of our Oracle database details, I decided to use Power BI to organize that information.
- Must have Oracle client installed on computer
- Must have a tnsnames.ora file to connect to Oracle database
- Connecting to Oracle Database
The server entry is actually the entry in your tnsnames. Example below
Also fill in the select statement for the view that you want
In the next window choose database and then supply database credentials