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.

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.

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

      The OP indicated that this was for a non scheduled refresh situation. For scheduled refreshes yes, we are using power bi.  Thanks