Forum Discussion
The underlying connection was closed: An unexpected error occurred on a send(Sharepoint data Only)
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 Wifi3. In General Tab, click properties.
4. Uncheck Internet Protocol Version 6 (TCP/IPv6)
Click "OK"
Hope this solves your problem.
Same error.
I source data mainly from sharepoint.
Dataset refreshed finer before.
So is this a connectivity issue/bug ? or can it be cuased by something I define on my side ie Power Query ?
I was able to resolve this issue by replacing my home internet router. I previously was using the Verizon FIOS provided router. I changed firewall settings, TLS, Packet sizes, everything mentioned in any thread about this issue. I was also noticing other issues with Microsoft products on that same router.
Examples: In MS Teams, someone shares a file location , click the link and immedtiately get an error in the browser. Refresh it, nothing. Refresh it again, and it loads perfectly.
Also, just to be sure it wasn't a PowerBI Specific error, I was getting the same "failure on a send" message when using PowerQuery in Excel to reach an ODBC connection.
With FIOS ( my ISP), the actual modem is in a permenant terminal attached to the house, so it cannot be changed. The home router can be changed. I changed it to a stanrd, commercialyl available mesh router system and all of the errors immediatetly were resolved.
My only advice is is that if you are experiencing this error on a particular connection, and its happens to be a FIOS provided router, the only current answer seems to be changing the hardware.