Forum Discussion
'Oracle.Databases.Client' could not be instantiated
dennisr you need to install the Oracle ODP.net driver:
32bit: http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html
64bit: http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
The ODC library has been deprecated.
I should have mentioned... I had already done that.
I installed ODAC112040Xcopy_64bit.zip
I already had instant client 11 installed prior, both 32 & 64 bit, and my PATH had the 64 bit folder before the 32 bit folders.
After I installed ODAC, into a completely new folder (c:\Oracle), I put c:\Oracle and c:\Oracle\bin into the front of my PATH and removed the prior folders from the path.
I'm striking the same error. It seems like an obvious bug to me that you can navigate and preview the data using whatever drivers, but then you cant generate a visual.
dennisr - did those steps your described in your last post solve your problem?
I just didn't have time to continue playing with it, as I was just evaluating PowerBI. So, I just did "Import" rather than direct. I stil suspect it's related to some 32 vs 64 bit issue.
Thanks Dennis. I think my machine has both Oracle 32 and 64 bit drivers, but they were the older 11GR2 client.
Following that tip from @pquian I downloaded the "64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64" (ODAC121024_x64.zip), and installed it using the default settings. It now seems to be working.
It still seems like a clear bug to me that you can connect and model using some Oracle Drivers, but can't visualise until other drivers are installed. Surely all PBI tasks should use the same drivers? There are lots of other risks e.g. inconsistent drivers, performance, TNSNAMES configurations.
