Forum Discussion

shekhar_shres's avatar
shekhar_shres
Advocate II
3 years ago
Solved

The underlying connection was closed: An unexpected error occurred on a send(Sharepoint data Only)

Hi all, Thank you in advance for taking the time to read this post. I have built some dashboards where the data comes from Sharepoint as well as our SQL server. So prior to 9/12/2022 everything...
Need Help
  • shekhar_shres's avatar
    shekhar_shres
    2 years ago

    Hi everyone, I raised the ticket with Microsoft and finally found the solution this problem.

    Follow the following steps.

    1. Go to Control Panel > Network and Internet > Network and Sharing Center > Change adapter settings 
    2. Double Click on Wifi 

    3. In General Tab, click properties.
    4. Uncheck Internet Protocol Version 6 (TCP/IPv6)

    Click "OK"

    Hope this solves your problem.

pratyashasamal's avatar
pratyashasamal
Memorable Member
3 years ago

Hi shekhar_shres ,

Check transport layer security (TLS) 1.0 and 1.1 for Power BI. 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/

Thanks ,
Pratyasha Samal 
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

shekhar_shres's avatar
shekhar_shres
Advocate II
3 years ago

Hi pratyashasamal, 

Thank you for your response. Where do I add the follwoing code 

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

The link provided does not direct me as to where to add the code. 


Also, I'm already in TLS 1.2