Oracle Cloud to Power BI service using Azure VPN connection

[sintezators]

Hello,

I am looking for a way to use Oracle Cloud (cloud, not on-prem) as Power BI dataset (web version, not desktop).

It is able to use Oracle Cloud database from Power BI Desktop but this is not what I'm looking for as it takes time and this connector takes a lot of time to refresh, so it would be great if PowerBI could do this all process `in cloud`.

Is there any way to connect Oracle Cloud to Power BI service?

My idea of all this was to create Azure Local Network Gateway and S2S VPN connection to my Oracle Cloud (what I already did) so Azure would act like "on-prem Oracle Cloud gateway". But now I can't figure out how to properly use this when setting up dataset in PowerBI service.

I searched anywhere for a solution for this and this took too many days for me trying to achieve this so maybe someone of you have experience or any ideas about my way to get this done. 

Thank you in advance,

Edmunds.

[alexkeh]

Here is a tutorial for connecting Oracle Autonomous Database on the Oracle Cloud with Power BI cloud.... You will need to use Power BI Pro, Premium, or Trial. I've tried these instructions and they work, though I didn't try it with Azure VPN.

[GilbertQ]

Hi @sintezators 

Unfortunately this is not possible. Currently the only cloud supported data sources are from Azure and Snowflake. 

You will have to use Power BI Desktop to connect to your data and then also use the Gateway to refresh your dataset. You could look at using Incremental refresh so it does not take so long to refresh the entire dataset?