Forum Discussion

RakeshP's avatar
RakeshP
Helper I
10 years ago
Solved

Having issues with Connect to Oracle database

Hi ALL,   I am trying to connect to oracle database from Power BI Desktop(PBID), but it is throwing below error.   Unable to connect   we encountered an error while trying to connect   Detail...
Need Help
leeann_g's avatar
leeann_g
Frequent Visitor
10 years ago

I'm having the same problem and even after I download the Oracle client that corresponds to my Orable DB version and install it am receiving the following error:

 

Details: "The provider being used is deprecated: 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.'. Please visit https://go.microsoft.com/fwlink/p/?LinkID=272376 to install the offical provider." 

 

Are there other steps we should follow to complete the connection? Or other things that need to be modified? If so, where and what files need to be modified? I get to the point of entering my DB credentials and then it fails with the error. This feels like a significant bug.

 

  • pqian's avatar
    pqian
    Microsoft Employee
    10 years ago

    leeann_g the client version need not match the server version. I think this is the version you want:

     


    ODAC 12c Release 4 and Oracle Developer Tools for Visual Studio (12.1.0.2.4)
    Download the File [Released October 5, 2015]
    Download ODTwithODAC121024.zip 304 MB (319,813,071 bytes)

    • leeann_g's avatar
      leeann_g
      Frequent Visitor
      10 years ago

      That worked after removing all other versions, and making sure that I had the x64 version, of course. Still encountering some other issues at the query execution and filtering level, but that helped me over the connection hurdle. Thank you!

       

      This would be a great thing to have included in the Prerequisites checklist or in the installation package for PowerBI itself.

      • pqian's avatar
        pqian
        Microsoft Employee
        10 years ago

        leeann_g What are some of the query execution issues? We'd be interested to hear.

         

        Unfortunately we cannot bundle Oracle drivers in PBI desktop (licensing issues). However, we'll be updating the FW link you get when the driver is missing, so that it points to the right address.