Not able to connect oracle database from power bi desktop 64 verion

[saivina2920]

I am using power bi past 6 years. i am connection various source like, Oracle, SQL, Excel, SAP, etc.

I am trying to refresh my report and to connect oracle db from power bi destop 64-bit version. The refresh was working past few years.

suddenly, last two days i am not able to connect oracle database.

getting error below.

Error : 

DataSource.Error: An error happened while reading data from the provider: 'Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.'
Details:
DataSourceKind=Oracle
DataSourcePath=mpnaxupr

Below is my version details :

Power BI ==> Version: 2.103.881.0 64-bit (March 2022)

Oracle ==> 12.1.0

Also installed ODAC driver ==> ODAC122010Xcopy_x64

What is the exact problem...?

why this error coming recently...?

Note : till last week the report and refresh was working fine. But, past two days, i am not able to connect oracle db..

This is very very urgent and project getting hold due to this error..

pls. help

Reference Microsoft Link ==> https://community.powerbi.com/t5/Desktop/Oracle-32-Bit-Drivers-with-64-Bit/m-p/825529 

[theov]

Check this out for oracle connection 🙂
https://www.youtube.com/watch?v=EpeJrO5tHDc

[v-tangjie-msft · Accepted solution]

Hi @saivina2920 ,

1.Make sure you have the correct Oracle client installed on your machine. Power BI Desktop (64-bit) requires the 64-bit Oracle client to be installed. You can download the client from the Oracle website.

2.Make sure you have the correct version of the Oracle client installed. Power BI Desktop (64-bit) requires version 12.2.0.1 or later of the Oracle client.

3.Check the connection string you're using to connect to the Oracle database. Make sure it's correct and complete, including the server name, port number, database name, username, and password.

4.Make sure you have the correct driver installed for connecting to the Oracle database. In the Power BI Desktop "Get Data" window, select "Oracle" from the list of data sources and make sure you have the correct driver selected. If the driver is not listed, you may need to install it.

5.Check your firewall settings to make sure they're not blocking the connection to the Oracle database.

6.Try using a different method of connecting to the Oracle database, such as ODBC or OLE DB. You can find these options in the "Get Data" window in Power BI Desktop.

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. 

[saivina2920]

Can anyone reply for the same...?

This is very very urgent...