A Very Basic Question on Connectivity

[Anonymous]

Hi,

We are evaluating Power BI Cloud for a client.

Can someone inform How to connect Power BI Cloud Version(app.powerbi.com) with Oracle Database? Where Oracle Database resides behind a firewall and we can connect that database only using client VPN.

Regards,

Zahid Rahim

[v-luwang-msft]

Hi @Anonymous ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[arvindsingh802]

For Onpremise data sources you have to install and configure Power BI Gateway On-premises data gateway - Power BI | Microsoft Docs

Make sure you allow required URLs from Gateway server Adjust communication settings for the on-premises data gateway | Microsoft Docs

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!

[Anonymous]

Thank you for the reply.

1. Can we install on-premise Gateway on a third System other than the Server where Oracle Database is installed?

2. I cannot see Oracle Database Connection place on "app.powerbi.com" where can i find this ?

[arvindsingh802]

1. Yes you can install it to any machine/server which running 24*7 within client network
   Make sure you install 64 bit Oracle driver on same machine Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Docs

2. After completing first step, You can use Dataflow to pull data from Oracle to App.PowerBI.com

Creating a dataflow - Power BI | Microsoft Docs

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!