I can't connect to Autonomous Data Warehouse

[Antonio795]

Hello everybody

I was using Oracle Client release12.1 and Power BI was running well until 2 days ago, when i get this window:

using SQLPlus I get the same error:

Then I changed to Oracle Client 12.2 and wasn't detected by Power BI:

but using SQLPlus the connection was enable:

I tried installing the 64-bit ODAC 12.2c Release 1 (12.2.0.1.0) Xcopy for Windows x64 but still not working, getting the same error.

Dou you know another way to solve this? 

[selimovd · Accepted solution]

Hey @Antonio795 ,

you can try the ODBC connection.

But for me it seems to be a problem of the Oracle client. Maybe try to uninstall, reboot and do a fresh installation.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[Antonio795]

I had to delete everything related to Oracle Client even in REGEDIT of windows, because Power BI still did not recognize the oracle client.

Then I installed 64-bit ODAC 12.2c Release 1 (12.2.0.1.1) for Windows x64 and check the NET option as enable, and Power BI connected with Oracle Autonomous.

Thanks