DataSource.Error: SharePoint: Request failed: The underlying connection was closed: An unexpected...

[LukeWalker]

Receiving the following error on connecting to SharePoint:

DataSource.Error: SharePoint: Request failed: The underlying connection was closed: An unexpected error occurred on a send.

This is from the following M code:

let
   Source = SharePoint.Files("https://#########.sharepoint.com/sites/#########/")
in
   Source

No issues with this query up until a few days ago when the Power BI service refresh began failing. Refresh fails in desktop as well. I've read up on existing support articles, checked I am using TLS 1.2 locally (would not affect the service regardless), and I am unable to find further ideas why this would suddently begin failing. Interestingly, the query does succeed ~10-20% of the time at random. 

I am able to connect to the SharePoint site via the SharePont.Contents function ~50% of the time, but needing to query multiple files from the site. I tried deleting and recreating the data source, no dice.

Version: 2.116.884.0 64-bit (April 2023)

[LukeWalker]

Turned out my issue was just the VPN connection I was on. Once I resolved that, the source started working fine.

[Jwilcox555]

This was exactly the reason for me as well. Strange that this is the case, but it did fix it when I logged on to my VPN. Typically in the past just a connection to Sharepoint hasn't required a VPN. 

[Phills88]

I have exactly the same issue...

[lbendlin]

Usually this means your sharepoint is overloaded.  Are you getting a lot of 429s too?