Forum Discussion

alisoroush7's avatar
alisoroush7
Helper I
1 year ago
Solved

Encountering SSL TLS error in web connection

Hi guys, I'm trying to connect to a data source using web connection. My web url does not have https so i got the SSL/TLS error. How can I turn off the SSL/TLS check or is there any alternative meth...
  • Anonymous's avatar
    Anonymous
    1 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
        Source
    

    Web.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.