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 (13)
RE: One single schedule task for sequential refresh of both Dataflows + Dataset
Hello,
We are missing this so badly, yes. Especially now that you got them flowing through the deployment pipeline, which is great, a big congrats for that. I have a deployment pipeline with twentysome dataflows now and it's becoming hard to mantain. The work pace together with the use of partial deployment make the pipeline a bit a black box so sometimes is difficult to understand what the combination (definition + data) in each stage might be!. In addition, as linked entities aren't supported in the pipeline, some workarounds on that can make the things worse. The one I have chosen only finds that there is a missing column when the dataset fails to load it. As it imports the data "as it is" and "watever it is". I have ended selecting columns as a last step for each dataflow so that expliciting them triggers the error if they are missing.
Thank you!
Javier
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.