How to set auto refresh order in power bi service

[Anonymous]

Hi,
We have 1 report and 1 dataflow (which is an input source to report) in a single workspace and we have scheduled auto-refresh for both in Powerbi service.

Current behavior -> Report is getting auto-refreshed before dataflow.

Expected behavior -> Dataflow should be auto-refreshed before the report (as dataflow is an input to the report).

Thanks.

[ibarrau · Accepted solution]

Hi. You can refresh de Power Bi Semantic Model (report) after dataflows in two ways. One would be manually configuring schedules. If you know dataflow takes 15 minutes to refresh you can configure dataflow for 8am and the power bi semantic model of the report at 8.30am.

The automated alternative is using the Power Bi Rest API or Power Automate. You can check the status of the dataflow refresh in order to know if it's ready. At Power Automate there is a trigger "when a dataflow refresh completes". You can use that one to run the next Semantic model refresh of the report. The example is configured here: https://hatfullofdata.blog/refreshing-datasets-automatically-with-dataflows/

You can read more about it at microsoft docs too: https://learn.microsoft.com/en-us/power-query/dataflows/trigger-dataflows-and-power-bi-dataset-seque...

I hope that helps,