This problem will occur when running in 64 bit mode with the 32 bit Oracle client components install

[ndc_ctr]

Hello Team

I am facing issues with my Power BI report

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.'

I updated ODAC (ODAC112040Xcopy_64bit) but facing same issues/error.

Please give a quick solution.

-- Anurag Arun Edlabadkar

[v-yuta-msft]

Hi ndc_ctr,

This may caused by a mispatch between 32-bit version and 64-bit version component. What's your power bi desktop version? If you are using 32-bit version, you should install 64-bit version instead. Please refer to: https://docs.microsoft.com/en-us/power-bi/desktop-connect-oracle-database#installing-the-oracle-clie.... In addtion, install 32-bit mode Oracle client instead of 64-bit Oracle client.

Regards,

Jimmy Tao

[ndc_ctr]

Hello Jimmy,

I do have 64 bits Power BI and doesn't help.

I do have 64 bits SQL Developer.

I do have OS Windows 10 Pro 64 bits.

Oracle client is 64-bits.

Still I am getting this error.

Please help.

[bwilx]

ndc_ctr, did you ever resolve this?  I am getting the same error with SSIS package which is trying to connect to Oracle.  On-premises

[v-yuta-msft]

Hi ndc_ctr ,

I would recommend you to create a support ticket here for further support.

Regards,

Jimmy Tao