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

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'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.

Related content