One single schedule task for sequential refresh of both Dataflows + Dataset
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.
really need it, an automated trigger to all the report built on dataflow when the last one refreshes!
Olivier Travers commented
I describe how to do this with the Power BI API and Flow in the community forum:
Lawrance A commented
This idea is really needful. I looking for this new feature in Power BI
Joshua Chartier commented
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.
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.
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.
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.
This would be a great step towards easing/automating the management of PBI data model refreshes.
A much needed feature that would further boost the capabilities (almost end to end)