cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rlee1982
Helper III
Helper III

Schedule refresh for every first day of a month

I am trying to refresh my dataset every first day of a month.

 

Power BI service and Power Automate can only schedule the refresh based on different days (Sun, Mon, etc.) of a week, but the first day of a month is not necessary on extact day.

 

Does anyone know how to do it?

 

This issue seems bug many people since 2017 😥

 

Many thanks!

1 ACCEPTED SOLUTION
Migasuke
Solution Specialist
Solution Specialist

Hi @rlee1982 ,

Power BI can't do it at this moment in Schedule Refresh, but Power Automate can.
This set up should refresh your dataset every 1st of the month:

Migasuke_0-1657036467797.png

 

View solution in original post

3 REPLIES 3
Migasuke
Solution Specialist
Solution Specialist

Hi @rlee1982 ,

Power BI can't do it at this moment in Schedule Refresh, but Power Automate can.
This set up should refresh your dataset every 1st of the month:

Migasuke_0-1657036467797.png

 

Thanks Migasuke! It works! Just one more question: can we select to update ALL datasets in the workspace? Now I can only select one dataset one time. Thanks! 

Migasuke
Solution Specialist
Solution Specialist

Hi,
I don't think you can do ALL, but definitelly you can do several. In your flow you just need to select action for parallel branch. Result would look something like this:

Migasuke_0-1657044412235.png


In case you need to refresh ALL datasets in your workspace / tenant - best is to use REST API. It is a bit more advanced since you need to write your own code, but with some youtube channels it is not that difficult.

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors