Forum Discussion
Linked Dataflows, Tables and Refreshes - confused
HI royces99 ,
If you need to have modifications to a dataflow you can do that in Dataflow 2. You link in the Dataflow1 results and then reference (or merge or append) the Dataflow1 result to make a new query with your modifications.
As you mentioned though, the catch is the timing. Dataflow2 does NOT make dataflow results refresh. This is two separate refreshes and so you have to know about how long a normal refresh for Dataflow1 takes to complete and then schedule Dataflow2 to be after that completes. And, I strongly recommend that you leave buffer time - sometimes dataflows do not start at the exact moment you want and sometimes they run longer than you think.
HI royces99 ,
If you need to have modifications to a dataflow you can do that in Dataflow 2. You link in the Dataflow1 results and then reference (or merge or append) the Dataflow1 result to make a new query with your modifications.
As you mentioned though, the catch is the timing. Dataflow2 does NOT make dataflow results refresh. This is two separate refreshes and so you have to know about how long a normal refresh for Dataflow1 takes to complete and then schedule Dataflow2 to be after that completes. And, I strongly recommend that you leave buffer time - sometimes dataflows do not start at the exact moment you want and sometimes they run longer than you think.
On my company's IT estate, I can set the Dataflow and Semantic models to refresh on the hour and at half past each hour (so every 30 minutes). Each one only takes a few minutes though. Dos this mean that if Dataflow refreshes at 1pm, then Dataflow 2 won't pick up those updates until 1.30pm and then the semantic model at 2pm? Or will Dataflow 2 update immediately following Dataflow 1 at 1pm (or 1.05pm say)? Just trying to work out how long it takes from a data change at source to make it to the Power BI report for the user, and if eliminating a Dataflow would make it quicker?