Forum Discussion
'Oracle.Databases.Client' could not be instantiated
In PowerBI, I can "Get Data", and the columns appear in the "Fields" section. However, when I select a field, this error appears: "Could not load the data for this visual" Error:The managed prov...
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:
Couldn't load the data for this visual
We reached the enterprise gateway, but the gateway can't access the on-premises data source.
Please try again later or contact support and provide the following details to help resolve your issue faster.
Please try again later or contact support and provide the following details to help resolve your issue faster.
Error CodeDM_GWPipeline_Gateway_DataSourceAccessError
...
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.