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.

Jason_C's avatar
Jason_C
Regular Visitor
3 years ago

Hi Shekhar,

I am having a similar experience. I use power query mainly in excel but I'm seeing the same behaviour in PowerBi.

The problem started c. Feb 6.

Refreshing using my mobile phone hotspot works and refreshing from external locations, cafes etc works. At home, when I start my laptop and connect to my home internet I get the same error as you re connections to SharePoint files.  If I temporarily switch to my mobile phone hotspot and then switch back to my home internet then the queries refresh without error until I shut down my laptop and then start again.

I have a colleague with the same internet provider as me with and she experiences the same behaviours and other colleagues with different providers don't have any refresh problems! However, I have a colleague in a different country who does experiences the errors. I wonder is there some setting in Sharepoint that has changed and causes a conflict with certain internet connections/providers?