Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Data flow single table refresh

does Data flow can single table  refresh? how to do it?
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi Anonymous ,

     

    as far as I'm aware refresh is set for the Dataflow and not for individual tables in it.

     

    1. In this scenario I'd have two Dataflows, one with the Fact table and one with the Dimension tables. Then set a different refresh time for each Dataflow.

     

    2. Or use linked entities. 

    • Links in the same workspace: If you have dataflows A, B and C in a single workspace, and chaining like A > B > C, then if you refresh C, then you'll have to refresh others independently. However, if you refresh the source (A), the downstream entities also get refreshed.
    • Links between workspaces: 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.

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi Anonymous ,

 

as far as I'm aware refresh is set for the Dataflow and not for individual tables in it.

 

1. In this scenario I'd have two Dataflows, one with the Fact table and one with the Dimension tables. Then set a different refresh time for each Dataflow.

 

2. Or use linked entities. 

  • Links in the same workspace: If you have dataflows A, B and C in a single workspace, and chaining like A > B > C, then if you refresh C, then you'll have to refresh others independently. However, if you refresh the source (A), the downstream entities also get refreshed.
  • Links between workspaces: 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.

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.