Connect Power BI Service to Autonomous Database through Power BI Gateway
Image Source: https://big2smart.com/the-power-bi-gateway-a-practical-case/
Continue from previous post, Microsoft Power BI Desktop Connecting to Oracle Autonomous Database, in this post, I will write about Power BI service connecting to ADB through Power BI Gateway.
As usual, only key steps are written in detail, some steps are overlapped from the previous post, please refer there, thanks.
Steps:
- After setup Power BI Desktop and connect to ADB, create sample graph, then publish to Power BI Service.
- Install and configure Power BI Standard Gateway.
- Install and configure Oracle Client for Microsoft Tools 19c where BI Gateway is installed.
- Configure BI Gateway on published graph dataset.
- Verify if report and dataset on Power BI Service is working correctly.
Publish Graph to Power BI Service
Create some sample graph and publish to Power BI Service.
Select where on Power BI Serivce to save sample graph.
Successfully published to Power BI Service.
Install and configure Power BI Standard Gateway
Download Power BI Standard mode from here.
Install BI Gateway.
Sign in the same account as you sign in BI Desktop.
Configure BI Gateway after signed in.
Done.
Install and configure Oracle Client for Microsoft Tools 19c where BI Gateway is installed
Please follow Step 3 and 4 in Microsoft Power BI Desktop Connecting to Oracle Autonomous Database to setup Oracle Client for Microsoft Tools 19c.
Configure BI Gateway on published graph dataset
Now, login to Power BI service, same account you used to login BI Desktop and BI Gateway. Go to the workspace where sample graph was uploaded and click on settings.
Expand Gateway and cloud connections, you would see that the BI Gateway is registered in BI Service but is not configured correctly. Click Add to gateway.
Configure a new connection through BI Gateway.
If everything is configured correctly, you will be redirect back to Gateway settings. You would see Gateway is up and running now. Map data source in your sample graph dataset to the connection just created and apply.
Verify if report and dataset on Power BI Service is working correctly
Click on report to see if report is shown correctly.
Sameple graph is shown if everything is configured correctly.
Click refresh manually to verify if configured correctly.
That’s it for this post, thanks for watching!
Reference:
What is an on-premises data gateway
Install an on-premises data gateway
Connecting Microsoft Power BI Service to Oracle Autonomous Database and On-premises Database
