Microsoft Power BI Desktop Connecting to Oracle Autonomous Database
Image Source: https://medium.com/oracledevs/connecting-microsoft-power-bi-to-oracle-autonomous-database-69ddfcb712ca
Due to project requirement, this is a brief step by step walk through Connecting Power BI Desktop to Oracle Autonomous Database. Only the key step is written in detail. Please see all referenced posts at the bottom.
Steps:
- Provision Autonomous DB and download client credential (Wallet)
- Install Power BI Desktop on source device
- Install Oracle Client for Microsoft Tools 19c
- Configure Oracle Client for Microsoft Tools 19c
- Connecting Power BI Desktop to Autonomous DB
Provision Autonomous DB and download client credential (Wallet)
In my lab, I chose Secure access from everywhere for convenient purpose.
Download Wallet after ADB is provisioned.
For simplicity, I unzipped the Wallet file at c:\
Install Oracle Client for Microsoft Tools 19c
Download the software from here or here.
Install the tool.
This is a VERY IMPORTANT step, choose the directory where you unzipped the downloaded ADB Wallet, which is located at c:\ from my previous step.
Finish the installation.
Configure Oracle Client for Microsoft Tools 19c
Within the Wallet folder, if you are accessing one ADB, modify sqlnet.ora. If you are connecting to multiple ADBs, modify tnsnames.ora.
For my lab, I modified sqlnet.ora from this
to this.
Modification for accessing multiple ADBs, please refer to reference at bottom
Connecting Power BI Desktop to Autonomous DB
Copy the descriptor’s name from tnsnames.ora, such as XXX_high, _low or _medium depends on your needs.
Open Power BI Desktop, choose Get data from another source.
Choose Oracle Database.
Input the descriptor’s name copied from previous step.
If everything is configured correctly, you will be able to see all data within ADB.
That’s it for this post. Next, I will write a post regarding Power BI service connecting to ADB through Power BI Gateway. Stay tuned!
References:
Connect Power BI and Microsoft Data Tools to Autonomous Database
Connecting Microsoft Power BI Desktop to Oracle Autonomous Databases and On-premises Databases
Installing Oracle Client for Microsoft Tools Tutorial
Connect to an Oracle database with Power BI Desktop
Connecting Microsoft Power BI Desktop to Oracle Autonomous Database, from Alex Keh.
