The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to 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.
Check this out for oracle connection 🙂
https://www.youtube.com/watch?v=EpeJrO5tHDc
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.
Can anyone reply for the same...?
This is very very urgent...
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |