Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Oracle 32 Bit Drivers with 64 Bit

Hi All,

I am trying to connect to a Oracle DB using Power Bi desktop 64 bit. I have downloaded ODAC122011_x64 from the oracle site and configured the tnsname.ora with my server details. The file is on my C Drive C:\app\myname\product\12.2.0\client_1\Network\Admin\Sample

 

However I am getting the following error in Power Bi;

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=(description=(address=(protocol=tcp)(host=xx.xx.xx.xx)(port=1553))(connect_data=(server=dedicated)(service_name=myserver)))

 

The only drivers I have installed are from the Oracle download which are 64 bit, so I am confused and sure not what the next step should be. There doesn't seem to be other drivers installed and there aren't any Oracle services running.

 

Thanks

 

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

hi, @Anonymous 

You need to install the recommended provider which can be found in following links.

For 32-bit versions of Power BI Desktop, use the following link to download and install the 32-bit Oracle client:

For 64-bit versions of Power BI Desktop, use the following link to download and install the 64-bit Oracle client:

Please take a look at this document, it should be helpful to you.

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

@Anonymous 

For us sometimes it helps to input the server name in connection screen of PBI as xx.xx.xx.xx/ServiceName

This is not dependant on TNSNames. Though it needs a Oracle driver of same bit.

Anonymous
Not applicable

I have fixed the driver issue, but now I get a error saying that there is no listener.

Anonymous
Not applicable

@Anonymous Have you tried the connection/server name this way

xx.xx.xx.xx/ServiceName

Anonymous
Not applicable

Hi All,

 

If anyone has this problem the correct format is <server name>:<port>/<service name> it finally works for me.

Thanks for the replies.

Anonymous
Not applicable

Hi,

I tried it, but it still doesn't work.

As you can see below, I have this pop up.

liilkenj_0-1648817699529.png

 

v-lili6-msft
Community Support
Community Support

hi, @Anonymous 

You need to install the recommended provider which can be found in following links.

For 32-bit versions of Power BI Desktop, use the following link to download and install the 32-bit Oracle client:

For 64-bit versions of Power BI Desktop, use the following link to download and install the 64-bit Oracle client:

Please take a look at this document, it should be helpful to you.

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.