Multiple Oracle Components Installed - causing issue connecting

[anddav87]

Hi

I am trying to connect Power BI to an Oracle database.

I am using Power BI 64-bit so have downloaded and installed the Oracle ODAC component, 64-bit.  I have put that location in my PATH variable as well as the \bin folder.  I have my TNSNAMES.ora under TNS_ADMIN variable.

However I get this error when trying to connect:

We encountered an error while trying to connect.  Details: "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.'"

The machine does have a 32-bit client installed which is required for something else.  It's not an option to uninstall it.

Is there a way to "force" PowerBI to use the 64-bit component I just installed?

Thanks in advance

Andy

[v-shex-msft]

Hi @anddav87,

Based on your error message, this issue seems due to compatibility between 32bit and 64bit(datasource and connector), please refer to below link to know more about this:

Attempt to load Oracle client libraries threw BadImageFormatException

Regards,

Xiaoxin Sheng

[anddav87]

Thank you, unfortunately that doesn't help me solve the issue

[v-shex-msft]

HI @anddav87,

I also not so sure why this exception appears, normally it will use the correspond oracle connector.
I'd like to suggest you to use udl to test these connectors if it works on your side.

Basics first : "UDL Test"

BTW, you can also try to submit a support ticket for this issue.

Submit a support ticket

Regards,

Xiaoxin Sheng