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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
AdrielMoro
New Member

Prevent auto refresh for linked Dataflows in the same workspace

Hi friends, 

 

Is it possible to prevent the default behavior described below?? 

https://learn.microsoft.com/en-us/power-query/dataflows/linked-tables

 

AdrielMoro_0-1731525451212.png

 

Here's my scenario: I have three dataflows that load data, and a fourth dataflow that combines data from the previous three. However, I'm experiencing an issue with auto-refresh. Whenever I refresh one of the first three dataflows, it triggers the fourth one to refresh. Ideally, I want to perform a refresh (manually or via Power Automate) only after the three dataflows have completed loading

1 REPLY 1
rajendraongole1
Super User
Super User

Hi @AdrielMoro - Unfortunately, Power BI doesn’t provide a direct option to disable this cascading refresh feature for linked dataflows. However, you could avoid linking dataflows directly by exporting the data from the first three dataflows into separate storage, such as an Azure Data Lake or OneDrive, and then configuring the fourth dataflow to pull from those storage locations. This can help prevent the automatic refresh trigger.

In Power BI Dataflows, the default behavior of cascading refreshes occurs when a dataflow references another dataflow. This means that whenever you refresh any of the first three dataflows, the fourth dataflow, which depends on them, will automatically refresh as well.

 

alternatively, 

Use Power Automate to orchestrate the refresh process. You can set up a flow that:

Monitors the completion of refreshes for the first three dataflows.
Once all three are refreshed, triggers the refresh of the fourth dataflow manually.
This approach ensures that the fourth dataflow refreshes only after the three upstream dataflows are updated.

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors