Forum Discussion

BugmanJ's avatar
BugmanJ
Helper V
1 year ago
Solved

Dataflow Refreshing by Daisy Chaining

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 ti...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.