Forum Discussion

Arul's avatar
Arul
Super User
3 years ago
Solved

Oracle database connection issue

Hi All, I am trying to connect Oracle Database to Power BI, I am facing below issue even after installing the latest ODAC. Could anyone help me to solve this issue while connecting data to Oracle D...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Arul ,

     

    Please try:

    (1)Remove the redundant ODAC clients from your computer, or uninstall and reinstall one all to ensure that only 1 ODAC client exists.

    (2)Ensure that the only ODAC installed meets all requirements.

     

    • Oracle Data Access Client (ODAC) software must be installed on the computer running Power BI Desktop. Installed ODAC must:

      • be version 11.2 or greater
      • match the version of Power BI Desktop installed: 32-bit or 64-bit
      • be compatible with your Oracle Server
      • be Windows installer version (since xcopy version does not work with Power BI)
      • have the “Configure ODP.NET and/or Oracle Providers for ASP.NET at machine-wide level” enabled by selecting the corresponding checkbox during the setup wizard
      • include the ODP.NET drivers

    (3)Try downloading Power BI Desktop from the Download Center instead of the Microsoft Store and downgrading to ODAC 11.x.

     

    Best Regards,

    Neeko Tang

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Arul ,

 

Please try:

(1)Remove the redundant ODAC clients from your computer, or uninstall and reinstall one all to ensure that only 1 ODAC client exists.

(2)Ensure that the only ODAC installed meets all requirements.

 

  • Oracle Data Access Client (ODAC) software must be installed on the computer running Power BI Desktop. Installed ODAC must:

    • be version 11.2 or greater
    • match the version of Power BI Desktop installed: 32-bit or 64-bit
    • be compatible with your Oracle Server
    • be Windows installer version (since xcopy version does not work with Power BI)
    • have the “Configure ODP.NET and/or Oracle Providers for ASP.NET at machine-wide level” enabled by selecting the corresponding checkbox during the setup wizard
    • include the ODP.NET drivers

(3)Try downloading Power BI Desktop from the Download Center instead of the Microsoft Store and downgrading to ODAC 11.x.

 

Best Regards,

Neeko Tang

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