Forum Discussion

DataSundowner's avatar
DataSundowner
Helper II
4 years ago
Solved

Refresh Multiple Dataflows and One Dataset Sequentially

Hello everyone. I have a Dashboard/Dataset that connects to 3 dataflows. I've set up the refresh schedule for dataflows. What I want to achieve is to refresh the Dashbaord/Dataset after all those 3 s...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    Doesn't have to be repetitive.  Each dataflow can be updated as needed.  Technically you can set up the action only for dataflow 3 -> dataset 1 and dataset 4 -> dataset 2,  and then a separate flow that refreshes the dataflows in sequence.   

     

    This is all "event driven" (*)  so no repetition.

     

    *)  Microsoft marketing speak for incessant polling.

mbbozzuto's avatar
mbbozzuto
Advocate II
3 years ago

Thanks lbendlin - yeah, the data source is not compute resource constrained and is scalable for parallel processing.  I will look at the parallel Power Automate flow branching.  Ideally, there will be a Power Automate component that triggers the refresh of the data flow but also waits until it receives a refresh complete response from the data flow (subject to a timeout limit, which should then cause an error in the Power Automate flow and stop processing).

lbendlin's avatar
lbendlin
Super User
3 years ago
Ideally, there will be a Power Automate component that triggers the refresh of the data flow but also waits until it receives a refresh complete response from the data flow

There is not.  You need to write that part yourself.