cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mike_honey
Advisor

Re: 'Oracle.Databases.Client' could not be instantiated

Actually it's working fine for me on multiple machines.  The key seems to be installing and configuring that 64-bit ODAC client driver on all machines.

Topgun Frequent Visitor
Frequent Visitor

Re: 'Oracle.Databases.Client' could not be instantiated

Hi All,

 

I still get this error. We installed ODAC 12c release and installed Oracle Data Provider for .Net 12.1.0.2.0. And from Power BI Edit Query, I preview data, but when I create Visual report, I got error 

Error Message:
The managed provider 'Oracle.DataAccess.Client' could not be instantiated. Unable to find the requested .Net Framework Data Provider. It may not be installed.

 

Here is detail. Did I miss any setup? Appreciate any help. thx

 

Tom

 

Topgun Frequent Visitor
Frequent Visitor

Re: 'Oracle.Databases.Client' could not be instantiated

Hi,

 

I faced same issue now. I have ODAC 12c installed, and my Power BI desktop version is Version: 2.42.4611.901 64-bit (January, 2017). In Power BI desktop. I can view data in Edit Query windows, but when I added to visual, I got error The managed provider 'Oracle.DataAccess.Client' could not be instantiated. Unable to find the requested .Net Framework Data Provider. It may not be installed. I saw you solve the issue by configure ODAC, here is what I have ODAC component installed. Not sure missed anything. 

 

PowerBIOracle01.PNG

 

Appreciate any help.

 

Thanks

Tom

mike_honey
Advisor

Re: 'Oracle.Databases.Client' could not be instantiated

Is your Oracle install 64-bit?

niroberts Frequent Visitor
Frequent Visitor

Re: 'Oracle.Databases.Client' could not be instantiated

Folks - I ran into this issue and have been troubleshooting all afternoon.

 

My initial config...

  • PBI desktop 64bit (june 2017 release) installed
  • existing 11g 32bit Oracle client
  • new 12c Oracle Data Access client installed
  • path updated to place new 12c Oracle home first

Even after downloading and installing the ODAC 12C and updating my path, my PBI desktop continued to throw errors when trying to build a viz with direct connection to Oracle Database.

 

I downloaded the 32bit version of PBI Desktop and it works as expected... no issue.

 

My question is - can we have 32bit and 64bit Oracle clients side-by-side whereby we are able to use PBI Desktop 64bit and Visual Studio (SSDT) to develop SSRS reports?  The PBI desktop wants the 64bit ODAC and Visual Studio wants the 32bit client!!

 

Help please...

 

Thanks - Nick 

Knud Regular Visitor
Regular Visitor

Re: 'Oracle.Databases.Client' could not be instantiated

We have the 32-bits and the 64- bits oracle driver installed on our machines. We use 64 bits Power BI Desktop (may release). We use Excel 32 bit. And both tools can connect to an Oracle database.

 

In the PATH variable we have first the 32-bits settings and after that the 64-bits settings.

niroberts Frequent Visitor
Frequent Visitor

Re: 'Oracle.Databases.Client' could not be instantiated

Thanks @Knud - I actually worked through the issue last night.

 

In my haste (and ignorance)  I didn't install the full Oracle client 64 bit - only the ODAC components.

So, after deinstalling all Oracle clients I did the following which resolved the issues:

 

1. Install Oracle 12c 64bit Client into a specific directory ie. "c:\oracle64" 

Oracle Database Client (12.1.0.2.0) for Microsoft Windows (x64)

 

2. Install Oracle 12c Oracle Data Access Components 64 bit into the same directory (c:\oracle64).

64-bit ODAC 12.2c Release 1 (12.2.0.1.0) for Windows x64

 

3.  Install Oracle 12c 32bit Client into another specific directory ie. "c:\oracle32"

Oracle Database Client (12.1.0.2.0) for Microsoft Windows (32-bit)

 

The results are good for my situation.  I am now able to connect to an Oracle database from PowerBI desktop 64bit without issue.  Additionally I can build visualizations over the connection.  Finally my Visual Studio projects which use oracle connections also function as expected - using the 32bit Oracle client.

 

~Nick

Re: 'Oracle.Databases.Client' could not be instantiated

Problem exists at this moment at our company when files are based on direct query. Still looking for the solution. Any help????

Fout Power BI.png

 

SoumyaPuppala Regular Visitor
Regular Visitor

Re: 'Oracle.Databases.Client' could not be instantiated

@Hyperchef1969 , i also have same problem for direct query, is it solved for you.

If yes, can you please let me know 

 

Thanks,

Soumya

Re: 'Oracle.Databases.Client' could not be instantiated

Check if server password is not expired. That was the problem in our case.

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors