Forum Discussion
Data flow refresh order
Hey Drunken_Sailor ,
I'm wondering if you have Power BI Premium?
Chaining, is exactly what we are doing by using linked entities. Most of the time to create staging/transforming/loading chains, this works perfecly. So I'm wondering if you are using linked entites, but as I already mentioned - this is a Premium feature (but also available with Premium Per User).
This article explains the premium features of dataflows in more detail: Premium features of dataflows - Power BI | Microsoft Learn
Regards,
Tom
Hi Tom, Premium per user is what I have. Take a look at the refresh log of some of your linked queries within a dataflow. Look at the start times and you'll probably notice that the start at the same time. For example. If query A gets data from another flow, and B uses A to get some data from another source, and C then uses B to get soemthing from soemwhere else, when the dataflow is started, A status is "skipped", not sure why it says that, but okay it gets the latest info, and B and C start at the same time. Now B takes longer to run as it looks at something and then filters out the unwanted. C should then pick up after that and just get the rest of the data that is required. However, C finishes, according to the log, before B. Just strange.
My workaround was to move some of the steps to a semantic model. Then use Power Automate to trigger the semantic mode, when the first dataflow finishes and then "delay" some minutes and start antoher step. Its not optimal, but it works.