Forum Discussion
Oracle.DataAccess.Client - direct query error
I finally got a solution:
I installed an older version of 64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64 and it worked as expected:
https://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
Hi Anonymous ,
According to your description and error messages, I think this issue should more related to compatibility between power bi desktop latest version and oracle client.
I'd like to suggest you open support ticket one power bi/oracle support page.
submit a support ticket
Regards,
Xiaoxin Sheng
I finally got a solution:
I installed an older version of 64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64 and it worked as expected:
https://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
Quick follow up question on this, as I've had the same problem for a long time...
Is your Power BI installed from the Windows Store or from the desktop download link?
I've found that the Store version doesn't work nicely with Oracle Clients - but if your older Oracle Client version works OK then I may have to revert to that client as it drives me mad having to manually download Power BI regularly rather than let the Store manage it for me!
Anonymous :
I have installed it from the following link: https://www.microsoft.com/en-us/download/details.aspx?id=58494
I had the same problem and fixed it with your suggestion. I was using ODAC version 12.2 and I downgraded to version 12.1. Thanks!
Hello Anonymous
Do you uninstall first version 12.2?
Do you have to configure again your odbc credentials?
Thank you.
Anonymous: I did not have to uninstall the 12.2 Oracle client. I just created a second Oracle-Home on my computer. There was also no need for re-configuration of odbc-credentials since I am using tnsnames.ora for specification of the target databases.