Forum Discussion

hpppppp1206's avatar
hpppppp1206
Frequent Visitor
2 years ago

Get Data with connection to Oracle Database face errors

There are 2 issues I faced:

1. Recommended provider ('Oracle.DataAccess.Client') is not installed. You can continue with your current provider, however it has been deprecated and may not work correctly. 

However, I followed the instruction that Microsoft has suggested by downloading the Oracle Client for Microsoft Tools from below site:

Microsoft Learn more: Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Learn

Oracle download site: https://www.oracle.com/database/technologies/appdev/ocmt.html 

 

After downloaded:

I run the installer.

Successfully installed for Unmanaged Data Access option.

 

After I click ok for the issue 1. I proceed to connect my server with below interface:

 

2. Issue "An error happened while reading data from the provider: 'No ODAC driver is found on the system. Please visit https://go.microsoft.com/fwlink/p/?LinkID=272376 to install the provider.'"

While I have installed all the required drivers that stated in documentation.

I have also crosscheck my environment variables

 

I have crosscheck the registry as well

 

 

I also tried to install ODAC 19c separately, but when I run as admin for the install.bat, it pops and disappear in a sec.

Hope I could get some help here.

 

Need Help

3 Replies

    • hpppppp1206's avatar
      hpppppp1206
      Frequent Visitor
      2 years ago

      Based on the solutions you paste, I have verified from my end for the suggested solution from the comments.

       

      You need to install the latest version of "Oracle-Client-For-Microsoft". 

      -- I have installed

       

      I downloaded the x64 version, ran the installer and the only thing I changed was the second file path where it asks to point to tnsnames.ora/sqlnet.ora. Gave it the correct file path to my TNS folder and that was it.

      -- I also place the correct path that carrying the tnsnames.ora file for connection to database

       

      I also ensure both Power BI desktop app and the OCMT are 64-bit.

       

      My Power BI Desktop Session Diagnostics:

       

      Feedback Type:
      Frown (Error)

      Timestamp:
      2024-08-19T05:30:26.4790955Z

      Local Time:
      2024-08-19T13:30:26.4790955+08:00

      Session ID:
      e680d22c-dc5b-4322-9456-5b05b266ff74

      Release:
      July 2024

      Product Version:
      2.131.1203.0 (24.07) (x64)

      OS Version:
      Microsoft Windows NT 10.0.22631.0 (x64 en-US)

      CLR Version:
      4.8 or later [Release Number = 533320]

      Peak Virtual Memory:
      71.5 GB

      Private Memory:
      772 MB

      Peak Working Set:
      1.14 GB

      IE Version:
      11.1.22621.0

       

      Model Default Mode:
      Import

      Model Version:
      PowerBI_V3

       

    • hpppppp1206's avatar
      hpppppp1206
      Frequent Visitor
      2 years ago

      Hi Adam,

      I have verified the suggestion solutions from comments under your shared link.

       

      > I downloaded the x64 version, ran the installer and the only thing I changed was the second file path where it asks to point to tnsnames.ora/sqlnet.ora. Gave it the correct file path to my TNS folder and that was it. 

      I did this, pointed the path to my tnsnames.ora for database conn.

       

      I also ensured both Power BI Desktop and OCMT are latest and 64bits.

      I also tried uninstall client tool and reinstall. It seems doesn't help.

       

      I still facing "No ODAC driver is found on the System".