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.
Hi,alisoroush7 .
Has your problem been solved?
If you have found suitable solutions, please share them as it will help more users with similar problems.
For example, relevant code or links to articles.
Or you can mark the valid suggestions provided by other users as solutions.
Thank you very much for your understanding and support of Power BI.
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.