Forum Discussion

Maheshwari's avatar
Maheshwari
Regular Visitor
1 year ago

Oracle database connection issue with PowerBI desktop

  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...
Need Help
rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

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's avatar
Maheshwari
Regular Visitor
1 year ago

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