Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Power BI Desktop DirectQuery Oracle Autonomous Data Warehouse Issue

Hi,

 

Has anyone successfully used "Power BI desktop" or "Microsoft Power BI Desktop (Optimized for Power BI Report Server - August 2018)" DirectQuery Oracle Autonomous Data Warehouse (it's an Oracle Cloud Data Warehouse based on Oracle 18.0.3.3)?

 

There is no problem to use import mode, but encountered "Couldn't load the model schema" in DirectQuery Mode.

 

Client information as below:

-Windows Server 2016 Standard
-Power BI Desktop (August 2018) ver2.61.5192.641 64-bit
-Oracle 64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Daniel,

     

    I fixed the issue: When install Oracle provider/driver have to check the box "Configure ODP.NET at machine-wide level" in ODP.NET step.

     

    Thanks for your help!

    Angi

2 Replies