“When a Power BI dataset refresh completes” trigger in Power Automate

If you have been working with Power BI for a while now you might have come across the standard Power BI actions in Power Automate. They allow you to automate a nice bunch of Power BI processes. But while there is a trigger that starts a flow when a Power BI dataflow action has completed, no such trigger is available for when a Power BI dataset action has (successfully) completed. So here I will present a workaround that is still possible without a premium Power Automate license.

Use a data driven alert in Power BI

Just create a data driven alert in Power BI with a threshold that will be reached with every refresh of the dataset. You can do this by setting a dedicated “Trigger-Flow”-measure to 1 for example. Then configure the data driven alert to trigger every time the measure is above 0.  Within the data driven alert, choose the option to “Use Microsoft Power Automate to trigger additional actions”. That will create a new flow that will trigger whenever the dataset refreshes.

Option to create a flow in Power Automate when the dataset refresh finishes

Limitations

As you can see in the screenshot above, this method will not work more than once in an hour. But for most workloads withing a pro workspace this will probably be sufficient.

Enjoy and stay queryious 😉

Leave a Reply

Die Datenschutzbestimmungen finden Sie hier: / Please find the privacy policy here: https://wp.me/P6lgsG-Rz