on 27 Nov 2018 17:07:47
If I create a dataflow that takes input from different dataflows, the refresh of that dataflow cannot be scheduled at the same time, as the refresh returns an error. I am only able to schedule on the whole or half hour, so I have to wait at least 30 minutes before my subsequent flow can be up to date.
Come to think of it, the same applies to refreshes from PowerBI. If I try to refresh my Power BI dataset from dataflows, it returns an error if that dataflow is in a refresh.
- Comments (1)
RE: Improve dependence on other (refreshing) dataflows
It would be nice to have more control over refreshes. For instance, we have a set of about 10 dataflows that feed about 3 datasets. These dataflows are all close in refresh duration so I can't guarantee which one will end last. In Power Automate, I can't setup a flow to have the completion of a set of dataflows (i.e. wait until they all complete) trigger the refresh of the datasets, a trigger can only rely on a single object. I could setup a sequential Power Automate flow i.e. take my two longer dataflows, have one trigger the other and then trigger the dataset, but this is clearly clunky and isn't really solving the issue of needing dataflows grouped together and completion of the group triggering the firing of dataset refreshes.