cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kenny_i Member
Member

Connect to Oracle Autonomous Data Warehouse Cloud is supported?

I would like to connect to Oracle Autonomous Data Warehouse Cloud with Power BI. Is this possible?

 

Is this possible? Anybody tested? Or any article saying it is possible.

 

Ken

 

3 REPLIES 3
Moderator v-yuezhe-msft
Moderator

Re: Connect to Oracle Autonomous Data Warehouse Cloud is supported?

@kenny_i,


Have you tried the Oracle connector in Power BI Desktop? Based on this article, as long as you install required Oracle client in the Power BI Desktop machine, you are able to use Oracle connector in Desktop to connect to Oracle Autonomous Data Warehouse Cloud.

In addition, as per this article, it is possible to create ODBC dsn for Oracle Autonomous Data Warehouse Cloud. In this case, you can use ODBC connector in Power BI Desktop to connect to the dsn.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
angiwang Frequent Visitor
Frequent Visitor

Re: Connect to Oracle Autonomous Data Warehouse Cloud is supported?

Yes, you can.

You can use import mode, but I'm encountered "couldn't load the model schema" in DirectQuery mode.

angiwang Frequent Visitor
Frequent Visitor

Re: Connect to Oracle Autonomous Data Warehouse Cloud is supported?

I fixed the soltuion in DirectQuery mode, when install Oracle provider/driver have to check the box "Configure ODP.NET at machine-wide level" in ODP.NET step.