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.
Hi Team,
I am using Power BI service and want to set some of our report refresh monthly, but there isn't the option I want.
How can I set the refresh frequecny to Monthly?
Thanks,
May
Solved! Go to Solution.
Hi @mshao You would not be able to set monthly refresh data set except daily and weekly in power bi service. But you can achieve this using power automate.
If you interested, then you can follow the steps below:
1. Go to Power Automate and sign in with your Microsoft account. See image below:
2. Click on “Create” and select “Scheduled cloud flow.” See image below:
3. Configure the flow to run on the first day of every month. You can set the exact time you want the refresh to occur.
4. Click on “New step” + button and search for “Power BI.” See image below:
5. Select “Refresh a dataset” from the list of actions. See image below:
6. Choose your workspace and dataset that you want to refresh from left pane. See Image:
7. Save the flow and test it, and you are done.
Hope this helps!!
If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz
Hi @mshao You would not be able to set monthly refresh data set except daily and weekly in power bi service. But you can achieve this using power automate.
If you interested, then you can follow the steps below:
1. Go to Power Automate and sign in with your Microsoft account. See image below:
2. Click on “Create” and select “Scheduled cloud flow.” See image below:
3. Configure the flow to run on the first day of every month. You can set the exact time you want the refresh to occur.
4. Click on “New step” + button and search for “Power BI.” See image below:
5. Select “Refresh a dataset” from the list of actions. See image below:
6. Choose your workspace and dataset that you want to refresh from left pane. See Image:
7. Save the flow and test it, and you are done.
Hope this helps!!
If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz
Hi @mshao
Beside your dataset in MSfabric service you can see(...)
where we need go to settings there we have an option ScheduleRefresh
Then Choose Weekly as the refresh frequency
Select only one day of the Month (e.g., the first Monday of each month) and set the time for the refresh. This will limit the refresh to once per week.
login to your powerbi service and go to your workspace. and click on the three dots (…) next to its name.
Your dataset will now refresh automatically each month.
User | Count |
---|---|
45 | |
25 | |
22 | |
20 | |
18 |
User | Count |
---|---|
51 | |
45 | |
24 | |
24 | |
21 |