Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

jfinch

Power BI Dataflows now failing after running for 2 hours

Submitted by on ‎02-15-2022 02:52 AM

I have a number of Power BI Dataflows that have been running succcessfully however today they failed as they took 2 hours to run. Previously they only took 6-10 minutes. Is there a problem with 

Status: Accepted

If dataflows are in Premium workspaces, similar issue had been submited(ICM: 291701177)

The cause of this issue is a known workload distribution issue in the backend of premium dataflows.  

 

The current advice is to change the workspace to PRO and back to Premium when you are using GEN2 premium.

If the problem keeps occurring, we suggest following best practices on the Microsoft docs site to reduce the occurrence of the issue. https://docs.microsoft.com/en-us/power-query/dataflows/best-practices-developing-complex-dataflows

 

If there is any ETA for the full fix, would update here as soon as possible.

 

Best Regards,
Community Support Team _ Yingjie Li

See more ideas labeled with:
3 Comments (3 New)
Comments
v-yingjl
Community Support
Community Support
‎02-15-2022 05:45 PM
Status changed to: Needs Info

Whether there is any error message about this dataflow when it refreshed failed, did it relate to credentials, data size or refresh timeout.

 

You can consider sharing more details about this issue like data source type, workspace type, the size of the data source etc.

 

Best Regards,
Community Support Team _ Yingjie Li

shadow9600
Frequent Visitor
‎03-01-2022 02:31 PM

I began having Dataflow timeout issues over the weekend. Only seemed to happen on Dataflows that were accessing large views on Azure SQL Server. Converting the views to tables has allowed the dataflows to continue to refresh, but this was not an issue before 02/26/2022 and there were no changes on the views.

v-yingjl
Community Support
Community Support
‎03-01-2022 10:33 PM
Status changed to: Accepted

If dataflows are in Premium workspaces, similar issue had been submited(ICM: 291701177)

The cause of this issue is a known workload distribution issue in the backend of premium dataflows.  

 

The current advice is to change the workspace to PRO and back to Premium when you are using GEN2 premium.

If the problem keeps occurring, we suggest following best practices on the Microsoft docs site to reduce the occurrence of the issue. https://docs.microsoft.com/en-us/power-query/dataflows/best-practices-developing-complex-dataflows

 

If there is any ETA for the full fix, would update here as soon as possible.

 

Best Regards,
Community Support Team _ Yingjie Li

Idea Statuses