Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reports accessing same dataflow simultaneously fail

I have a dataflow that is shared between a few reports on import mode. Lately when the reports schedule refresh at same time in service they fail when accessing the same table from the dataflow. Either one or both reports fail to refresh. I then manually refresh one after the other and all is fine. 

Status: Needs Info
Comments
Anonymous
Not applicable

Hi  @Deece 

How often are you setting the scheduled refresh to refresh? Is this a recent problem or has it been a problem before? Are there any errors reported for simultaneous refreshes?

 

Best Regards,
Community Support Team _ Ailsa Tao

Anonymous
Not applicable

So it just failed again, referencing a different dataflow in the semantic model. Refresh schedule is twice a day 7:30am and 10:30AM UK.  This is a recent problem last 3-4 weeks, fine previously.

 

All failures are references to a dataflow 

 

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: DF Budget