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.
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.