Using Power Automate to schedule a refresh of a Power BI dataset at the time you want!
Below are the steps on how to use Power Automate to schedule a refresh of a Power BI dataset at the time you want it to.
I have recently seen some questions in the Power BI Community with regards to refreshing Power BI datasets. I thought it would be a good idea to blog on how to use Power Automate (Flow) to schedule a refresh of a Power BI Dataset.
The great news is that doing from Power Automate is that you can refresh the dataset anytime you want.
What I mean by this is when you try and configure a Power BI scheduled refresh you only get options on the hour or half hour as shown below.
Creating a scheduled refresh using Power Automate
In the steps below I will show you how I created a scheduled refresh to run at 07:14 AM every day in my time zone (which is AEST).
The first step is for me to log into Power Automate and then click on
The Scheduled cloud flow will allow you to schedule a time or multiple times to run the flow.
I then click on Skip, as I want to create it manually with some additional options
This then opens the editing window, I then search for “recurrence” and click on Schedule as shown below.
When the Recurrence step opens, I then select the Interval to be 1 and the Frequency to be Day. Meaning that this will run once a day.
I then click on “Show advanced options” as shown below.
I then clicked on the Time zone drop down and selected my time zone which is UTC+ 10 Brisbane.
Next, to have it run daily at 7am, I selected 7 “At these hours”
And finally, to run at 14 minutes past 7 I then selected or typed in 14 for “At these minutes”.
As you can see below the Preview is showing me when it will run.
Now before I go to the next step, I click on the 3 dots and select rename, allowing me to give the recurrence a meaningful name (which is useful to look at this when you come back to it sometime later).
It would now be a good idea to name the flow.
On the top left-hand side where it says “Untitled” change this to a meaningful name as I did with mine as shown below.
I now click on ” + New step” to add the step to refresh my Power BI Dataset. I now search for Power BI and select “Refresh a dataset”
I then select the workspace where I have my datasets, and then select the relevant dataset as shown below.
Once again, I rename this step to something more meaningful as shown below.
I then click on Save to save the flow.
The final step is to now test the flow to make sure it runs.
I then clicked on Test on the far right-hand side.
I then select Manually and click on Test
I then get the option to Run flow and click on Run flow.
Once the flow starts to run I then clicked on the Flow Runs Page
I could then see that it ran successfully.
NOTE: You can also click on the Start time to go into the actual flow and see how it ran.
And then I can see the successful steps.
I could now go into my Power BI Dataset in the Power BI Service and see that it successfully ran
Please note if you are using Power BI Pro you will only be able to run this 8 times a day.
In this blog post I have shown you how to schedule a Power BI dataset to be refreshed at any time you want to.
I hope you found this helpful and if you have any questions or comments, please let me know.
Have an awesome week!