Forum Discussion
Multiple updates are triggered by a single scheduled execution
- 1 year ago
Hi mh20221111,
Thank you for reaching out to Microsoft Fabric Community.
For the above issue please follow the below solutions:
- If the same dataflow is scheduled to update at close intervals or has overlapping schedules, power bi might mistakenly trigger multiple processes simultaneously. Review all scheduled refresh times for the dataflow. Ensure there is only one schedule per dataflow and no overlapping or duplicate schedules exist. Ideally, set updates at non-overlapping intervals.
- Long-running updates due to large datasets or complex transformations can cause the next scheduled update to overlap with the previous one. Use incremental refresh to process only new or updated data instead of the entire dataset. This reduces processing time and prevents overlapping processes.
- Power BI may retry failed updates automatically, which can create duplicate processes if the original update is still running. Implement incremental refresh for your dataflow to limit the amount of data processed in each update.
- Do not manually trigger an update close to a scheduled update time. If needed, ensure the schedule is paused temporarily.
- If the dataflow depends on other linked dataflows, ensure the refresh times are arranged properly so that linked dataflows finish before dependent dataflows begin.
- If you are on a shared capacity workspace, consider upgrading to Power BI Premium (Per User or Dedicated) to handle heavy data transformations.
By following the above solutions it prevents overlapping processes and improve the overall efficiency of Power Bi environment.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
Hi mh20221111,
Thank you for reaching out to Microsoft Fabric Community.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution i have provided for the issue worked? or let us know if you need any further assistance?
If my response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Anjan Kumar Chippa
Thank you for your response. I have confirmed with my team members, and we understand that this issue corresponds to the third point you mentioned: "Power BI may retry failed updates automatically, ...".
And we recognize that similar incidents may occur in the future.