Refreshing multiple dataflows that rely on each other - best approach?

[dufletch]

Hi all,

I have created a series of dataflows that connect to each other in a parent/child/grandchild type relationship. 

When a grandchild flow needs to be refreshed, its child and parent will need to refreshed prior to that in to ensure the grandchild it refreshing current data.

My question is this - if I schedule all "generations" of flows to refresh at the same time, will the service automatically recognise the dependencies and wait for a parent to refresh before it triggers the child refresh? Or should I schedule the parent to refresh half an hour before the child and so-on?

Thanks in advance!

[v-rzhou-msft · Accepted solution]

Hi @dufletch 

If you set the schedule refresh time at the same time, all dataflow will refresh at the same time.

So please set an interval between parent, child and grandchild.

And if your parent dataflow is complex and huge, please reserve enough time to refresh it.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.