Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
ChrisRenlund's avatar
ChrisRenlund
Advocate I
5 years ago

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)
ChrisRenlund's avatar
ChrisRenlund
Advocate I
5 years ago

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.

  • pawlowski6132's avatar
    pawlowski6132
    Helper V
    5 years ago

    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.