Oracle Database connection issue

[Anonymous]

Hello Folks,

While I'm trying to connect Oracle Cloud wallet in PBI Desktop getting error " Certificate validation failure". I tried different options by changing location path in sqlnet.ora but no luck. 

When I connected in SQL Developer & SQLPLus it's working fine but not in PBI Desktop.

Please let me know where it went wrong.

Thanks in advance.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Your error means that there may be something wrong in your Certificate.

I think you need to download the corresponding Oracle ADB credentials zip file to the system that has or will have Power BI Desktop installed. These credential files will be used to connect Power BI Desktop to ADB.

For reference:

Connecting Microsoft Power BI Desktop (BI) to Oracle Autonomous Database

Or you can try to export a wallet to a text-based PKI format and load your data into Power BI Desktop.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Hope you have installed Oracle Driver and added that to windows path.

If needed in the installed driver folder you will tnsnames.ora , do an entry there and try tnsname 

Description of the problem as all steps

https://community.powerbi.com/t5/Desktop/Getting-Power-BI-Desktop-to-work-with-Oracle-ODAC-after-version/m-p/1918220#M733122