Forum Discussion

russellj's avatar
russellj
Frequent Visitor
2 years ago
Solved

How to refresh all data sources for report in one shot?

Hello,   Given the following setup for a non-scheduled refresh report:     I end up having to one at a time refresh the Dataflow at the top (from another workspace), then refresh the Dataf...
dataflow
Need Help
  • aj1973's avatar
    aj1973
    2 years ago

    Hi russellj kblackburn 

    Refreshing the semantic model doesn't trigger the refresh of the Dataflows therefore the data in the semantic model stays as it was if the dataflows weren't refreshed. That's why it is a must to refresh the dataflows then after all refreshes have terminated then trigger the refresh of the semantic model to get the up-to-date data.

kblackburn's avatar
kblackburn
Icon for Advocate I rankAdvocate I
2 years ago

Having the same issue come up for on demand refreshes with non power users so I am setting up a Power Automate flow that will run when the first data flow completes. Maybe the same would work for you?

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi russellj kblackburn 

    Refreshing the semantic model doesn't trigger the refresh of the Dataflows therefore the data in the semantic model stays as it was if the dataflows weren't refreshed. That's why it is a must to refresh the dataflows then after all refreshes have terminated then trigger the refresh of the semantic model to get the up-to-date data.

    • kblackburn's avatar
      kblackburn
      Icon for Advocate I rankAdvocate I
      2 years ago

      correct, that is what I am doing in PA

      • aj1973's avatar
        aj1973
        Icon for Community Champion rankCommunity Champion
        2 years ago

        You can use schedule refresh in Power BI instead of Power Automate, you just need to choos the good time schedules for both Dataflows then for Semantic models.