Ingesting data from dataflow into report errors on scheduled refresh , fine with manual reattempt

[Anonymous]

Getting this error, the table referenced in error changes each time it fails but all are dataflow references about 10 dataflows used in report. But when i refresh report manually in service and desktop all is fine? This only started in last month or so. PPU workspace

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The underlying connection was closed: An unexpected error occurred on a receive."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"https://api.powerbi.com/powerbi/globalservice/v201606/clusterdetails"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: XXXXXX

[Vinizx3]

This usually happens due to intermittent connection issues between the Power BI Service and the Dataflows during scheduled refreshes, especially in PPU workspaces. The fact that the failure is intermittent and affects different tables each time suggests an infrastructure or service issue, not a problem with your data model. Try scheduling the refresh for off-peak hours or consider opening a support ticket with Microsoft if the issue persists