Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to Solution.
Hi @Anonymous ,
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:
Hi @Anonymous ,
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:
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:
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.
User | Count |
---|---|
45 | |
25 | |
22 | |
20 | |
18 |
User | Count |
---|---|
51 | |
45 | |
24 | |
24 | |
21 |