Forum Discussion
Oracle ORA-25700 Transport Layer Secutiry (TLS) connection error
correct! yeah it was an issue with company system. We all switched to 21c instant client, connectied via database option and it appears to be working!!
I have found the solution to your problem. The error occurs because when you connect to the database, Oracle asks you to authenticate the information to connect to the database.
On this screen:
Autenticação do banco de dados.
You will need to enter the username and password you created in the database. If you have SQL Developer installed, you can easily view it.
If you have already connected to the bank and you get this error when you click on Update, do the following:
In Power BI go to Power Query -> at the top click on "Data source settings" -> click on the name of the database that has a cylinder icon, for example "testebase" or as written in yours. -> A window will open with "Credentials in bold" and below it "Type: Database" and below that there will be two options "Edit" or "Delete". -> Click on "Edit". -> When it opens, as in the picture above, go to "Database" and enter your bank username and password and that's it. Problem solved.
Appreciate the reply. The company I work for uses the "Microsoft Account" option here which connect us directly
When I try with the "Database"option this is the error message I get. Not sure I can work around this...
- lbendlin
Super User
that's a "good" error message. Check your Power Query or Oracle SQL code - somewhere you are referencing a table that is either not there or not visible to your user.
correct! yeah it was an issue with company system. We all switched to 21c instant client, connectied via database option and it appears to be working!!
