Forum Discussion

nirrobi's avatar
nirrobi
Helper V
10 years ago
Solved

Can not connect to Oracle database - newest version

Hi all,   I have probplem that I can not get data from oracle in the newest version of Power BI Desktop version:2.35.4399.381 32-bit   When I try to get data from oracle I get immediatly the err...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi Nir,

    Based on the above error message, the connector might be corrupted. Please firstly uninstall your Oracle client if you have installed it before, then download the latest 32-bit Oracle client from this link and install it on your machine.

    Once the Oracle client is properly installed, enter the connection details in TNSnames.ora file, then connect to Oracle database from Power BI Desktop and check if it is successful. Alternatively, you can connect to the Oracle Database via EZConnect connection string. For more details, please review the following similar blog.

    http://www.powerpivotpro.com/2015/07/connecting-to-an-oracle-database-from-power-pivot/


    Thanks,
    Lydia Zhang

  • sdkearns's avatar
    sdkearns
    10 years ago

    NOTE:  Sorry.  Please disregard my response.  Didn't see earlier posts where you said you installed the most recent Oracle Instant Client.

     

    You may need to update your Oracle Instant Client version???

    I am using Oracle Instant Client 11.2.0.1.0 and accessing Oracle 11g database.

    Data Connections have been working in PowerBI Desktop until I installed May/June 2016 version of PowerBI Desktop.

    I think I need to update Oracle Instant Client to at least version 11.2.0.3.0.  I saw a matrix listing compatibility among versions, but I can't find it now.  I am going to try newer instant client version within the next day or so.

    If 11.2.0.3.0 doesn't work, will try instant client version 12.1.0.2.0

     

     

anithat's avatar
anithat
Resolver II
10 years ago

 

 

The issue is resolved. Installed the latest ODAC for 32-bit. Re-Installed the Power BI Desktop for 32-bit

 

nirrobi's avatar
nirrobi
Helper V
10 years ago

Hi,

 

I tried to uninstall oracle client and reinstall latest version but no luck.

 

I have oracle version 10 G

 

I only have problem to estblish new connection but I still can refresh older model.

 

Can anyone help please?

 

many thanks in advanced!

  • wonga's avatar
    wonga
    Continued Contributor
    10 years ago

    nirrobi

     

    Have you already tried installing the latest version of 32 bit Power BI Desktop after you reinstalled the ODAC components?

     

    Sometimes the uninstaller for Oracle doesn't completely remove everything, so it's possible you might have some lingering components on your computer that are conflicting with Powre BI Desktop.

     

    Have you also tried uninstalling both Power BI Desktop and ODAC and starting from scratch?

    • nirrobi's avatar
      nirrobi
      Helper V
      10 years ago

      I tried but it seems that something is missing on my computer (worl+home)

       

      The err appear too quick in my opinion:

      "

      The connector cannot be used because you are missing one or more required components

       

       

      what should I need to try to do?

       

      many thanks.

      • sdkearns's avatar
        sdkearns
        Frequent Visitor
        10 years ago

        NOTE:  Sorry.  Please disregard my response.  Didn't see earlier posts where you said you installed the most recent Oracle Instant Client.

         

        You may need to update your Oracle Instant Client version???

        I am using Oracle Instant Client 11.2.0.1.0 and accessing Oracle 11g database.

        Data Connections have been working in PowerBI Desktop until I installed May/June 2016 version of PowerBI Desktop.

        I think I need to update Oracle Instant Client to at least version 11.2.0.3.0.  I saw a matrix listing compatibility among versions, but I can't find it now.  I am going to try newer instant client version within the next day or so.

        If 11.2.0.3.0 doesn't work, will try instant client version 12.1.0.2.0