dataflow

[mandy5118]

In the below scenario assume that D is the table I use in the report which is a append of 1, A and B.

If I refresh DF1 and DF A then its obvious that the last dataflow would also refresh since it has 1 and A as linked entities.

Questions:

1. Does the final dataflow refresh twice?

2. If I refresh 1 and A together will it cause the last one, and hence the entire chain to fail? Any best practices?

3. If I care most about A and expect 1 to fail often, how can I ensure that the final DF does not fail? And my append happens with A and B with the new data and 1 with the old data (in the current scenario the entire flow would fail)

[Anonymous · Accepted solution]

Hi @mandy5118 ,

-- If I refresh DF1 and DF A then its obvious that the last dataflow would also refresh since it has 1 and A as linked entities.

Are you trying to say that A table_1, table_a, table_b in last_dataflow are linked tables reference from table_1 in dataflow_1, and table_a and table_b in dataflow_a?

1. Does the final dataflow refresh twice?

If so:

Configure and consume a dataflow - Power BI | Microsoft Learn

If both dataflow_1 and dataflow_a are refreshed independently and then cause final_dataflow to refresh, technically final_dataflow might be refreshed twice (Only referenced tables are refreshed). 

2. If I refresh 1 and A together will it cause the last one, and hence the entire chain to fail? Any best practices?

If dataflow_1 and dataflow_a are refreshed at the same time and their dependencies conflict or need to be refreshed sequentially, the chain may fail if not managed properly. You can ensure that one final_dataflow completes before the next begins by increasing the refresh interval of dataflow_1 between dataflow_a.

3. If I care most about A and expect 1 to fail often, how can I ensure that the final DF does not fail? And my append happens with A and B with the new data and 1 with the old data (in the current scenario the entire flow would fail)

What is the reason why dataflow_a fails to refresh often? 

Here are some guidelines for data flow optimization:

Understand and optimize dataflows refresh - Power BI | Microsoft Learn

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[miguel]

I'm moving this thread to the Dataflow Gen1 forum based on the previous reply

[mandy5118]

Its Gen1, Gen2 works very slow for me

[miguel]

Is this question for Dataflow Gen1 or for Dataflow Gen2?

There is no concept of linked entities in Dataflow Gen2