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
Guess you solved this, but for anyone else facing the issue - this is what solved it for us:
- Install Oracle Client 12.1 (64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64) as an additional Oracle home on your gateway server (we were running 12.2)
- Restart you On-premises data gateway (it did not work if you didn't restart the gateway)
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.