Forum Discussion
Encountering SSL TLS error in web connection
- Anonymous1 year ago
Hi,lbendlin ,rohit1991 ,thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Hello,alisoroush7 .I am glad to help you.
I hope my suggestions below are helpful:
1. Modify Power BI Desktop: do not check for deregistration information
URL:
Certificate revocation check, Power BI Desktop - Power BI | Microsoft Learn
2. Try creating a new power query, using Web.Contents().
Open Power BI Desktop and click Get Data > Blank Query.
In the Query Editor, use the Web.Contents() function to connect to your API.
for example:let Source = Web.Contents("http://your-api-url", [Headers=[Authorization="Bearer your-token"]]) in SourceWeb.Contents - PowerQuery M | Microsoft Learn
About authentication methods:
Since you mentioned that you are connecting to another server's API, each API may have a different authentication method, and you will need to contact the corresponding operations staff to find out the specific authentication requirements and how to obtain the necessary token or other authentication information.The Web.Contents() function supports HTTP connections so that SSL/TLS errors can be avoided.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
To bypass the SSL/TLS error in Power BI, try the following:
- Disable SSL certificate validation by going to File > Options and Settings > Options > Security, and uncheck the relevant SSL options. Alternatively, if using a self-signed certificate, install it into the Trusted Root Certification Authorities store.
I have unckecked all the relevant settings in option but it did not work. I am trying to retrieve data from an API from another local serever, what do you mean by installing the certificate?