Showing results for 
Search instead for 
Did you mean: 
Advocate IV
Advocate IV

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

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:

Source = SharePoint.Files("")

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)

Advocate IV
Advocate IV

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

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. 

New Member

I have exactly the same issue...

Super User
Super User

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

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors