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

 

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

 

Please help me.

Need Help

17 Replies

    • 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)

    • 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!

  • gusdcruz's avatar
    gusdcruz
    Helper I
    8 years ago

    Just want to share my experience here. Since I work in a coorporation everytime that I had to update Power BI I had to get admin rights, so I looked this issue up and someone here in the community recommended to download Power BI though Microsoft Store, so I did that so I didnt have to ask for admin rights, since then I started having problems connecting to Oracle Database, so this morning I decide to install Power BI through the web, and guess what, the problem went away. Dont ask me why, but this solve my problem.

     

  • anitaberg's avatar
    anitaberg
    Helper I
    8 years ago

    Hi! I have issue with the original issue. 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 official provider." 

     

    I have installed a complete test environment on my windows virtual PC, with Oracle database and Oracle business intelligence running.

     

    Now I have installed the corresponding ODAC to the version of oracle database I have, I believe.

     

    When I installed the ODAC software it created a client_2 in adition to the client_1 I hve in the c:app.... folder

     

    My guess is that Power BI is looking in the client_1 folder for the dll to use, when it should have looked in client_2 as that was created with the ODAC 64 bit install.

     

    Any help or tips on this?