Forum Discussion
Oracle Database connection issue
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.
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
