Forum Discussion
Refresh Multiple Dataflows and One Dataset Sequentially
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.
That flow is configured , uhm, interestingly. You need to handle the "wait until all three dataflows finished" differently. Ideally you would only schedule one dataflow, and then sequentially trigger the other dataflow refreshes upon success. Then you can trigger the dataset refresh when the third dataflow in the chain was refreshed successfully. (And you want to be alerted about each failure along the chain, so add extra actions for that)
Thank you lbendlin. I thought about that approach, but my next question is how should I schedule another dataset that also use one or two of these dataflows, do I have to refresh those dataflows again when I set up the flow for the second dataset? Say I have 2 datasets and follow what you said.
Dataset 1: refresh dataflow1, if success, refresh dataflow2, if successs, refresh dataflow3, if success, refresh the dataset 1.
Dataset 2: refresh dataflow2, if success, refresh dataflow3, if success, refresh dataflow4, if success, refresh the dataset 2 ?
If I understand corretly, part of the process of refreshing the dataset 2 looks repetitive and I don't want the same dataflow to refresh multiple times during the day.
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.
