Forum Discussion

Fatimardz10's avatar
Fatimardz10
Copper Contributor
Aug 27, 2021

Could not create SSL/TLS secure channel: power bi

Hello everyone!
I'm having troubles when trying to connect PowerBI to a database online, choosing the option "web" and adding a url with a xlsx file. There is nothing wrong with the url because if I click I'm able to download the xlsx. However, when I enter the url I get a message that says: "The request was aborted: Could not create SSL/TLS secure channel". I've tried to change security but couldn't fix it.
Thank you!
BI & Data Analysis
excel
power bi

1 Reply

  • evanchatter37's avatar
    evanchatter37
    Copper Contributor
    Oct 18, 2021

    The error is generic and there are many reasons why the SSL/TLS negotiation may fail. ServicePointManager.SecurityProtocol property selects the version of the Secure Sockets Layer (SSL) or Transport Layer Security (TLS) protocol to use for new connections; existing http://net-informations.com/faq/net/interview-questions.htm connections aren't changed. Make sure the ServicePointManager settings are made before the HttpWebRequest is created, else it will not work. Also, you have to enable other security protocol versions to resolve this issue:

    ServicePointManager.Expect100Continue = true;
    ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12
    SecurityProtocolType.Tls
    SecurityProtocolType.Tls11
    SecurityProtocolType.Ssl3;

    //createing HttpWebRequest after ServicePointManager settings
    HttpWebRequest request = (HttpWebRequest)WebRequest.Create("https://google.com/api/")

     

    If you create HttpWebRequest before the ServicePointManager settings it will fail and shows the error message.

     

Resources