Schedule refresh for every first day of a month

[rlee1982]

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!

[Migasuke · Accepted solution]

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:

[rlee1982]

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]

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:

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.