Oracle database connection issue with PowerBI desktop

[Maheshwari]

Hello All,

Could anyone help advise on the following issue?

I have been using an Oracle database for one of my Power BI projects. It was working properly on my old system with PowerBI desktop , but I recently changed systems because my old one reached EOL. After installing the necessary drivers on the new system, I installed the Oracle client for  Microsoft tools as per the documentation and defined tnsnames.ora in the specified location.

However, it seems that the Power BI Desktop backend service is not recognizing the Oracle driver installed on the C drive.

DataSource.Error: An error occurred while reading data from the provider: 'No ODAC driver is found on the system. Please visit this link to install the provider.'

Oracle installed location : C:\Program Files\Oracle Client for Microsoft Tools

Oracle tnsname folder : C:\Users\XXXXXXXXX\Oracle\network\admin

Thanks.

[rajendraongole1]

Hi @Maheshwari - check the power bi desktop systemtype 63 bitV application and oracle client with 32 in such scenerios we will get this errors. please check this , uninstall it and download/install the 64-bit version from Oracle’s official site.

Once done, run the command with Admin role. Run the following command to register the Oracle provider:

regsvr32 "C:\Program Files\Oracle Client for Microsoft Tools\bin\OraOLEDB.dll"

You can also test with Oracle SQL Developer to test the connection to your Oracle database using the same TNS entry. This helps confirm whether the problem is with Power BI or the Oracle setup itself.

Lastly check on you have proper access to the DB with assigned to start use .

Hope the above information helps.

[Maheshwari]

Hi @rajendraongole1 , Yes both powerbi and oracle were 64 bit version. I tried to connect using Oracle SQL developer. Its working good, able to access the DB.

Now I have uninstalled powerBI , oracle client for microsoft tools and installed 64 bit of both again.

But same issue persists. I couldn't find the file OraOLEDB.dll in the path you mentioned or any of the folder in "C:\Program Files\Oracle Client for Microsoft Tools".

Please advise.

Meanwhile, this is the snap from Task Manager taken duing oracle installation 64 bit version.

is this expected to show 32bit during 64 bit installation?

[rajendraongole1]

Hi @Maheshwari - can you check the snapshot shared, you couldn't find the OraOLEDB.dll file in the specified directory and that your Task Manager shows a 32-bit process during installation of the 64-bit Oracle client is concerning.

Look for the version in the file properties of the installer. Sometimes, even if it’s labeled 64-bit, the installer may default to 32-bit depending on how it's run

You might also consider downloading and installing the Oracle Data Access Components (ODAC) separately, which includes OraOLEDB.dll. You can find it below:

Oracle .NET, Visual Studio, and VS Code ODAC Downloads for Oracle Database

still issue it is better to connect with IT support team or ticket raise internally.

Hope this helps.

[Maheshwari]

Hi @rajendraongole1 , I have downloaded the below package ODAC21.14Xcopy_x64, but couldnot find dll file , Only OraOLEDB.tlb file found . Is this the exepcted pacakage to download?

Meanwhile i also tried to install oracle driver following the instructions in the website below.

Oracle Driver Installation steps (blueyonder.com).

In step 3, I got accessdenied errro even if i run with admin access.

Any idea on this?

Thanks,

Maheswari