Forum Discussion

Drunken_Sailor's avatar
Drunken_Sailor
Frequent Visitor
2 years ago

Data flow refresh order

Hello, In a workspace, I have serval dataflows When dataflow 1 is refrershed, it also refreshes the next dataflow (2).  And when Dataflow 2 starts it starts dataflows 3a, 3b, and 3c. I assumed th...
Dataflow
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Drunken_Sailor , are you using Scheduled Refresh to trigger the Dataflows.  I.e. start them all at 08:30.  If so, I would suggest switching to use Power Automate.  There is a Action (Start Dataflow Refresh) and Trigger (When Dataflow Refresh Ends) connectors that will allow you to run the Dataflows in a specific order or in parallel.  Here is video to get you started.
How to Refresh a Dataflow Using Power Automate 


  • Drunken_Sailor's avatar
    Drunken_Sailor
    Frequent Visitor
    2 years ago

    Dataflow A is scheduled to start at 8:30.  That then triggers B and C to start at the same time.  If instead I use Power Automate to trigger A, i get the same result. B and C will also get triggered at the same time.

    Sure, I could then use "when a dataflow refresh completes" to trigger B (which then triggers C) when A is finisshed, but that just means B gets refressed twice. If I then use another flow to trigger c when B is done, C get s triggered three times.  
    In this scenario, it is not a big deal, as the refresh cycles are only a few seconds, but I have others that take 2 to 3 hours each. They make API calls to a service that also limits how many you can do concurrently. Hence why I need these to be in a series and not in parrallell.