Forum Discussion

Koen_PoweredBy's avatar
Koen_PoweredBy
Frequent Visitor
3 years ago

Unexpected error: The underlying connection was closed: An unexpected error occurred on a send

Hi aill,    Since some time now I've been running into issues to connect to Sharepoint and Onedrive urls in Power BI Desktop. After I publish the report to the service the refresh works fine, so ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Koen_PoweredBy ,

 

Here I will give you some suggestions.

 

1. As far as I know, your issue will be caused by old version TLS.

 

Support for transport layer security (TLS) 1.0 and 1.1 for Power BI will end in June 2020. Upgrade the TLS version of your Power BI application to TLS 1.2 before then. 

 

Solution: Adding followung code  

System.Net.ServicePointManager .SecurityProtocol = SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12; 

 

Follow below post suggested by microsoft support team:

https://azure.microsoft.com/en-in/updates/power-bi-support-for-transportlayer-security/

 

2. You can clear permissions in Data source setting , then load the new credential to sharepoint and Onedrive and try again.

 

3. Download the latest Power BI Desktop version and try again.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Koen_PoweredBy's avatar
Koen_PoweredBy
Frequent Visitor
3 years ago

Hi, thanks for your response. 

 

1) Does this also apply to running a report refresh in Power BI Desktop? As I don't believe I am runninga Power BI 'application'. If it does apply, where / how should I apply that code? The post itself doesn't state that in enough detail for me to understand. I'm not an app developer. 

In the internet options of my laptop I already have TLS 1.2 enabled (default settings). 

 

2) I think that by this point I've cleared the permissions over a thousand times... I did so after every time after making any changes to my settings such as, clearing browser cache, changing default browser, uninstalling network driver, reseting the entire device to factory settings etc etc. It hasn't resolved my issue just yet.

 

3) I've already tried to re-install Power BI, I also tried an older version, but I get the same result. Also after the full laptop reset I did another re-install. The microsoft store version gives the same result as well. 

 

Thanks again for your response though. Any other ideas? Please do note my first post where I listed the solutions I've already tried so far.