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 Sage
Solution Sage

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
Solution Sage
Solution Sage

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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors