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 ...
BI & Data Analysis
excel
power bi
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