Forum Discussion

chris__1's avatar
chris__1
Advocate II
3 years ago
Solved

Datamart: refresh dataflows

This must be a commen question - however I have not found anything here or in the documentation: If I refresh a datamart that incluedes dataflows (from the same workspace): do I need to refresh the ...
Dataflow
Need Help
  • ibarrau's avatar
    ibarrau
    3 years ago

    Hi. I would say no. I don't think I have read anything about an automatic trigger from datamart to run a dataflow. You should configure dataflow schedule refresh and then the datamart schedule refresh.

    I hope that helps,

  • otravers's avatar
    otravers
    3 years ago

    The only dataflows that automatically get refreshed are parent dataflows when using linked entities. Dataset and datamart refreshes do not trigger parent dataflow refreshes. You are right, there are no orchestration/automation capabilities for datamarts at the moment, though I suspect it's just a matter of time.

chris__1's avatar
chris__1
Advocate II
3 years ago

thanks ibarrau 

 

still, if anyone come across this information on microsofts datamart documentation, a link would be highly welcome!

 

Also, if this is correct I think it would be a step back for me to use datamart. As the duration of refreshing dataflows can vary (or fail) I use Power Automate to refresh dataflows in the correct order and than as last step I refresh the dataset. Power Automate is missing the ability to refresh datamarts so I can not replicate this approach using datamarts!

 

  • otravers's avatar
    otravers
    Community Champion
    3 years ago

    The only dataflows that automatically get refreshed are parent dataflows when using linked entities. Dataset and datamart refreshes do not trigger parent dataflow refreshes. You are right, there are no orchestration/automation capabilities for datamarts at the moment, though I suspect it's just a matter of time.