cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
Super User
Super User

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

 



If my answer was helpful please give me a Kudos or even accept as a Solution.

Let's connect on LinkedIn!

View solution in original post

3 REPLIES 3
Migasuke
Super User
Super User

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

 



If my answer was helpful please give me a Kudos or even accept as a Solution.

Let's connect on LinkedIn!

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! 

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.



If my answer was helpful please give me a Kudos or even accept as a Solution.

Let's connect on LinkedIn!

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors