I want to configure a power automate flow to trigger a dataset refresh when previous run is complete

[Alice08]

I want to configure a power automate flow to trigger a dataset refresh when previous run is complete.

Is there any way we can detect the power bi dataset refresh history in power automate?

[v-veshwara-msft · Accepted solution]

Hi @Alice08 ,

Thank you for engaging with the Microsoft Fabric Community.

Just following up to check if your query has been resolved and whether the responses from @d_m_LNK  and @lbendlin  were helpful. If so, please consider marking the helpful replies as Accepted Solutions to assist others with similar queries.

Additionally, since this is related to Power Automate, posting in Microsoft Power Platform Community – Find Answers may help you get quicker and more accurate responses.

Thank you!

[d_m_LNK]

If you ingest this API data somehow (into a lakehouse or warehouse) - you could set up a simple report with all the refresh activities coming into a table.  Then on that report visual you could set up a reflex on it that triggers a refresh based on a new refresh record coming in.   A lot of background work but may do the trick.

[lbendlin]

You need to implement your own polling mechanism, either via the TOP 1 of the Refresh History (check for the presence of the End Date) or via a custom connector that implements the Enhanaced Refresh Request API call and using the Request ID to poll the status.

Avoid excessive polling, ask for the completion status not more frequently than every five minutes.

If you have the need to refresh continuously then you should consider switching to a Direct Query source instead.