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.

  • teljoy's avatar
    teljoy
    Regular Visitor
    4 years ago

    this solution alone was not enough to fix this problem - had to combine the accepted solution with the comment from "gusdcruz" to fix this problem   For multiple users in my organisation, the solution was to :
    1. Download and install latest ODAC from oracle as listed (in my case was no need to uninstall prev version)
    2. Uninstall all Power BI application/s installed via MS Store previously
    3. Go to https://powerbi.microsoft.com/en-us/downloads/ , choose Advanced download options(do NOT install via MS Store!) , then download x64/x86 as applicable and install
    4. Error fixed!