Forum Discussion
Oracle.DataAccess.Client - direct query error
Hi MS Power BI gurus, first of all I want to state my versions I am using for the upcoming scenario / question / problem: MS Power BI Desktop: 2.71.5523.941 64-bit (Juli 2019) Application OS...
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
NOTE: installing the second Oracle Home made some (not all) of our import dataset refreshes fail. Had to uninstall it to get the more important dataset refreshes working again - so now we're back where we started with our direct query that doesn't work.
Wish we had a solution for this. Same issue here. I had heard that running this internally on Report Server was a fix but, reading through this entire thread indicates it might now. I don't want to muck around with the ODAC becasue it could hose something else up.