Power BI
Under ReviewOne single schedule task for sequential refresh of both Dataflows + Dataset
on 27 Nov 2018 23:04:04
The biggest thing that I’m missing is the ability to schedule a Dataflow, plus a Dataset (without Premium capacity). Now you can schedule both separately, but not in an automated sequential way.
https://ssbipolar.com/2018/11/24/whats-missing-from-power-bi-dataflows/
- Comments (12)
RE: One single schedule task for sequential refresh of both Dataflows + Dataset
How long must we wait? This is becoming a deal breaker for me and the use of dataflows
RE: One single schedule task for sequential refresh of both Dataflows + Dataset
This is essential to be able to have a cohesive refresh of a dataset. It is difficult to predict always the length of the refresh of each part, so without a sequential refresh we end up with too many extra schedules "in case".
RE: One single schedule task for sequential refresh of both Dataflows + Dataset
ganz meiner Meinung
RE: One single schedule task for sequential refresh of both Dataflows + Dataset
really need it, an automated trigger to all the report built on dataflow when the last one refreshes!
RE: One single schedule task for sequential refresh of both Dataflows + Dataset
I describe how to do this with the Power BI API and Flow in the community forum:
https://community.powerbi.com/t5/Service/Dataflow-vs-Dataset-refresh/m-p/699601#M68755
RE: One single schedule task for sequential refresh of both Dataflows + Dataset
This idea is really needful. I looking for this new feature in Power BI
RE: One single schedule task for sequential refresh of both Dataflows + Dataset
Yes! Some optionality to cascade refreshes would really make things easier. Whether it's a push from dataflows to datasets (or other dataflows) as described by Kirsty, or a pull model from dataset or dataflows to the dataflows they depend on, cascading refreshes would really simplify the usage of dataflows. And I agree with the Anonymous comment that you'd have to include opt in permissions from both sides of the push or pull relationship so you don't allow unwanted refreshes.
RE: One single schedule task for sequential refresh of both Dataflows + Dataset
While I agree with the comments below, I think there may be cases where an automatic push from the dataflow to a dependent dataset might not be desired, so having the option to set a dataset as "yes, automatically ingest new dataflow data once the dataflow's refresh completes" or "no, I'll manage the refresh of the dataset myself" might be useful.
RE: One single schedule task for sequential refresh of both Dataflows + Dataset
This is a great idea. Having to set this option both in dataflows and datasets is a bit of a pain.
If you could enable the dataset to run a refresh as soon as the dataflow has completed would be a good step forward.
RE: One single schedule task for sequential refresh of both Dataflows + Dataset
Completely agree with this! The benefit of Dataflow is consistent data, but I'm going to have to put a lot of effort into aligning the models in different Workspaces to refresh at the same time AND after the Dataflow completes. An optional push option where it forces updates in the workspace model after data is updated in Dataflows.