Forum Discussion

rdnguyen's avatar
rdnguyen
Icon for Helper V rankHelper V
4 years ago
Solved

Dataflow chains

I set up a series of dataflows and set refresh for the 3 upstream.   This set of dataflows siphon pretty much a couple millions records and I have only 1 hour time to make its data fully flow downs...
  • v-cazheng-msft's avatar
    4 years ago

    Hi rdnguyen ,

     

    Is dataflow C built on dataflow A and dataflow B? If you would like to know the refresh logic of linked entities, you may refer to Link entities between dataflows - Power Query | Microsoft Docs. For links between workspaces and Links in the same workspace, the refresh logics are different.

    • Refresh for links from entities in different workspaces behaves like a link to an external data source. When the dataflow is refreshed, it takes the latest data for the entity from the source dataflow. If the source dataflow is refreshed, it doesn't automatically affect the data in the destination dataflow.
    • When data refresh occurs for a source dataflow, that event automatically triggers a refresh process for dependent entities in all destination dataflows in the same workspace, including any calculated entities based on them. All other entities in the destination dataflow are refreshed according to the dataflow schedule. Entities that depend on more than one source refresh their data whenever any of their sources are refreshed successfully.
    • The entire refresh process is committed at once. Because of this, if the data refresh for the destination dataflow fails, the data refresh for the source dataflow fails as well.

     

    Best Regards,

    Community Support Team _ Caiyun

     

    If this 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 me know. Thanks a lot!