Forum Discussion
'Oracle.Databases.Client' could not be instantiated
OK it worked ... for a while, all the way through to PBI Web querying via the Enterprise Gateway (after I installed ODAC121024_x64 on that machine).
But today it is working in PBI Desktop, but after re-publishing to PBI Web every visual returns an error:
Please try again later or contact support and provide the following details to help resolve your issue faster.
...
Digging into the PBI Gateway log I'm seeing lots of errors "Unable to find the requested .Net Framework Data Provider. It may not be installed.".
From the Settings / Gateways page the connection tests OK. I tried restarted the PBI Gateway service.
I instaled the ODAC121024_x64.zip. I verified that my PATH was updated with the leading
c:\OracleClient\product\12.1.0\client_1;c:\OracleClient\product\12.1.0\client_1\bin;
I still get the same error with the visual.
Problem exists at this moment at our company when files are based on direct query. Still looking for the solution. Any help????
I "frowned" the error this time, and got a reply back...
...This is an issue several customers have hit. We've fixed it in the upcoming release....
[I asked for ETA, and they said ...]
...our monthly release will be available on Thursday, May 26th. You will be able to download it at: https://www.microsoft.com/en-us/download/details.aspx?id=45331
I have exactly the same problem.
The Power BI Desktop version I use is 2.36.4434.381 64-bit (juni 2016).
So the problem is still not solved?
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.
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
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.
Appreciate any help.
Thanks
Tom
Is your Oracle install 64-bit?
Anonymous , i also have same problem for direct query, is it solved for you.
If yes, can you please let me know
Thanks,
Soumya
Check if server password is not expired. That was the problem in our case.
Installing the ODAC client resolved our issue.
