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.
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.
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.