Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThanks 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingIs 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingMarch 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
49 | |
28 | |
21 | |
20 | |
20 |
User | Count |
---|---|
52 | |
51 | |
26 | |
26 | |
22 |