Forum Discussion

Zhinee's avatar
Zhinee
Icon for Helper III rankHelper III
1 year ago
Solved

Power BI Oracle DirectQuery fails, but Import works – is it because I need to install Oracle client?

I’m trying to connect Power BI Desktop to an Oracle database using the same credentials and connecting to the same DB. Initially, Import mode also failed, but after checking the Enabled ODP Provid...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    1 year ago

    Hi Zhinee 

    Import mode works because Power BI can use the bundled ODP provider when you enable that option.
    DirectQuery does not support the bundled provider. It requires a locally installed Oracle client / ODP.NET (64-bit, matching your Power BI Desktop).

    To fix the issue, install the Oracle Data Access Components (ODAC) or Oracle Instant Client with ODP.NET, and make sure your PATH environment variable points to it.
    You can download the Oracle client here:
    Oracle Instant Client Downloads: https://www.oracle.com/database/technologies/instant-client.html

     

    Oracle Data Access Components (ODAC): https://www.oracle.com/database/technologies/dotnet-odacdeploy-downloads.html

     

    If you still face issues after installation, I recommend opening a support ticket with Microsoft for further troubleshooting.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
1 year ago

Hi Zhinee 

Import mode works because Power BI can use the bundled ODP provider when you enable that option.
DirectQuery does not support the bundled provider. It requires a locally installed Oracle client / ODP.NET (64-bit, matching your Power BI Desktop).

To fix the issue, install the Oracle Data Access Components (ODAC) or Oracle Instant Client with ODP.NET, and make sure your PATH environment variable points to it.
You can download the Oracle client here:
Oracle Instant Client Downloads: https://www.oracle.com/database/technologies/instant-client.html

 

Oracle Data Access Components (ODAC): https://www.oracle.com/database/technologies/dotnet-odacdeploy-downloads.html

 

If you still face issues after installation, I recommend opening a support ticket with Microsoft for further troubleshooting.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly