Forum Discussion

anddav87's avatar
anddav87
New Member
8 years ago

Multiple Oracle Components Installed - causing issue connecting

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

3 Replies

    • anddav87's avatar
      anddav87
      New Member
      8 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        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