Scheduled Refresh issues with Sharepoint

[Anonymous]

I have a report that run using data from Excel file in Sharepoint and data from SQL (setup through Power BI Gateway) but the scheduled refresh keep sending failure notice so I try to test the scheduled refresh with each source and find that:

_Scheduled refresh work fine with Sharepoint only dataset

_Scheduled refresh fail when use the above Sharepoint with Gateway data. I though the gateway is the issue but this is the error message:

Unable to connect to the data source undefined.Hide details

(I'm no expert but this mean Sharepoint is the issue right ? This exact Sharepoint work fine when run on its own and the full report with both data sources refresh just fine when I do it manually on PowerBI Desktop.)

Underlying error code:	-2147467259
Underlying error message:	SharePoint: Request failed: The underlying connection was closed: An unexpected error occurred on a send.
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind:	SharePoint
Microsoft.Data.Mashup.ValueError.DataSourcePath:	https://lfshare.sharepoint.com/sites/PowerBI684
Microsoft.Data.Mashup.ValueError.Reason:	DataSource.Error
Cluster URI:	WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID:	01559c10-2323-4318-81f7-99f5d50652e8
Request ID:	5d3775ad-735b-45af-8074-3ab20712384a
Time:	2023-01-05 07:17:51Z

[Anonymous]

Hi @Anonymous ,

We got the feedback from PG team:

Error "The underlying connection was closed: An unexpected error occurred on a send" is an issue with the network layer. Customer should reach out to their networking team with Wireshark traces and Fiddler traces collected upon reproducing the error in PBI Desktop to find why the connection is being closed. Customer can also check if there is any memory pressure as mentioned here - Database Connectors TSG | Power BI Documentation (eng.ms) 

The connection is being closed and is beyond the control of the connector.

Best regards.
Community Support Team_ Caitlyn