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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Kemei
Advocate I
Advocate I

Power BI dataflow scheduled refreshes sometimes fail with Execution Timeout Expired errors.

We have a couple of Power BI dataflows scheduled refreshes which sometimes fail when they have run over 10 minutes. The sources for the dataflow are Azure Synapes SQL pool and Office 365 Sharepoint sites. The below errors can be found in the log files.

 

DataSource.Error: Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

 

We've configured Incremental refresh and staggerd the schedules, but they still fail sometimes.

 

Is there a time out for 10 minutes setting for Power BI Dataflow Refresh somewhere? Can we increase the time out period? 

1 ACCEPTED SOLUTION

The dataflow itself will time out in the preview window after 10min, and no way to change that, but if you save it it will validate and process.

You could try to break your dataflow into 2 stages.

  1. Bring your Azure Synapse data into a dataflow with the other dataflow. No or minimal transformations.
  2. Create a 2nd dataflow that takes the tables from the first and does the big transformation. This will take advantage of the Enhanced Compute Engine and may process better. Doing everything in one dataflow when complex is usually discouraged.


Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

3 REPLIES 3
Kemei
Advocate I
Advocate I

Thanks for the reply. It is from a new Power BI dataflow with the complex transformations that combine the data from Azure Synapse SQL pool and other Dataflow. 

 

We are not sure where the 10 minutes timeout error comes from. Is it from Power BI services or Azure Synapse SQL pool?

 

The dataflow itself will time out in the preview window after 10min, and no way to change that, but if you save it it will validate and process.

You could try to break your dataflow into 2 stages.

  1. Bring your Azure Synapse data into a dataflow with the other dataflow. No or minimal transformations.
  2. Create a 2nd dataflow that takes the tables from the first and does the big transformation. This will take advantage of the Enhanced Compute Engine and may process better. Doing everything in one dataflow when complex is usually discouraged.


Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
edhans
Super User
Super User

Is this a new thing, or has it been happening for a while? Are you on Premium Gen 2? There are known issues described on this page. Known issue - Long running, failed or stuck dataflow in Premium Gen2 - Power BI | Microsoft Docs

I am not aware of a way to increase the timeouts.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.