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)
