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.
Yes I am trying to retrieve data from an API which the source software is in another server in our local network.
Are you able to resolve the issue?
I am also using WEB API json format and getting same error.
Could you please provide me the solution steps?