Dataflow Refreshing by Daisy Chaining

[BugmanJ]

Hello there,

Could someone please confirm the following:

I have 3x Data Staging Dataflows (DSD and 5x Validated Tables (VT) which build from these DSD.

The DSD are all refreshed at various times throughout the day, therefore because the VT are refrencing these DSD, and these DSD are set to refreshing at particular times, am I correct in thinking I do not need to setup refreshes for the VT (as long as I am happy with how often the DSD are refreshing) or do they still need refresh schedules set?

Many thanks

[Anonymous · Accepted solution]

Hi, @BugmanJ 

I am glad to help you.

Because VT are built on DSD, they are dependent on DSD data. If the VT references the DSD directly, and you are satisfied with the DSD's refresh frequency, then the VT should be able to reflect the latest DSD data without the need for a separate refresh schedule.

VT_Empoyer = ADDCOLUMNS(DSD_Employer,"IDs",COUNT(DSD_Employer[ID]))

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.