Forum Discussion

dennisr's avatar
dennisr
Advocate II
10 years ago

'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...
Knud's avatar
Knud
Frequent Visitor
9 years ago

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's avatar
niroberts
Frequent Visitor
9 years ago

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

Related content