cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Oracle Connection error 'Oracle.DataAcess.Client' Not Installed

I have been using PBI Desktop RS with an On-Premesis server for about a year now. My company is now moving to E5 licences so I'd like to start using PBI Desktop with cloud based reporting.

 

With Desktop RS I have no issues connecting to an oracle db, but with PBI Desktop I get the following error.

 

"The recommended provider ('Oracle.DataAccess.Client') is not installed. You can continue with your current provider, however it has been deprecated and may not work properly."

 

I can click ok and enter the server details on the next screen but when attempting to connect get the 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 official provider."

 

My understanding is that I already have this otherwise Desktop RS wouldn't work!?

 

The Desktop RS and Desktop versions are different as dictated by the managers of the RS.

 

Desktop RS = Version: 2.76.5678.1521 64-bit (January 2020)

Desktop = Version: 2.84.802.0 64-bit (August 2020)

 

My ODAC version should be ODAC122011_x64

 

Anyone able to shed any light on this?

1 ACCEPTED SOLUTION

Thanks all, I removed everything relating to Oracle and reinstalled.

 

Now working ok.

View solution in original post

5 REPLIES 5
Super User II
Super User II

Hi @mdex 

You will need the latest OBDC driver. To do that you will have to install / update your oracle client. There are upgrades releases to the way a driver connects so updating oracle client will help you resolve this issue.





PBI_SuperUser_Rank@1x.png
Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!👍
Linkedin Profile

Thanks all, I removed everything relating to Oracle and reinstalled.

 

Now working ok.

View solution in original post

Hi, @mdex 

Great to hear the problem got resolved! Could you accept your reply above as solution to close this thread?

Other community members will easily find the solution when they get the same issue.

 

Best Regards,
Community Support Team _ Eason

 

Super User IV
Super User IV

@mdex , Not very clear. as the desktop version is higher is needs the latest version of the oracle driver, that is what I can get from it.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

I thought that until I found....

 

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-oracle-database#installing-th...

 

Supported Oracle versions:

  • Oracle Data Access Client (ODAC) software 11.2 and later

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors