I found that using Power Automate to refresh Power BI Datasets allowed for refreshes to happen at the exact time I needed them to. This was because my underlying data warehouse load would vary, by using Power Automate it allowed me to have the Power BI Dataset refresh to happen as soon as my data was ready.
By using Power Automate and Power BI, it allowed me to quickly and easily create the process that has been successfully running for over a year now.
Below is how I got it all working together.
The first thing I had to do when creating the new flow was to identify a specific email which would kick off the dataset refresh.
In my example I did it in Power Automate by doing the following:
In the section where it said Subject Filter I put in the email subject I would get when the data warehouse has completed loading
Next I always test my Power Automate flow to make sure that it will work as expected.
In this post I have shown how easy it can be to create a Power BI Dataset refreshing using Power Automate to monitor my Inbox. Along with this to quickly and easily connect to the Power BI Dataset and refresh it when it is needed. This has really enabled the report consumers of the reports to get their data as soon as it is refreshed.
Not only that if the report consumers have got email subscriptions set up on the Power BI reports and dashboards those too will be sent as soon as the data has been updated.
Using Power Automate and Power BI has enabled the report consumers to make better data driven descisions.