Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

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

Dataflow
Need Help

1 Reply

  • Vinizx3's avatar
    Vinizx3
    Regular Visitor
    1 year ago

    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