Skip to main content
Microsoft Idea

Power BI

Under Review

Add "monthly" as a scheduled refresh option

Vote (3138) Share
Shawn Davis's profile image

Shawn Davis on 19 Aug 2015 23:26:55

Pro users have the ability to schedule refresh for daily (intra day) and weekly. For some datasets, monthly is the right cadence. Can we have a scheduled refresh option that is Monthly (and lets us choose which day of the month the refresh is to occur)?

Administrator on 21 Oct 2022 02:42:32

10/20/2022 - under review - Mo

Comments (253)
Shawn Davis's profile image Profile Picture

dk_power on 06 Jul 2020 00:15:01

RE: Add "monthly" as a scheduled refresh option

This is much needed Option.. Please include this ASAP.

Shawn Davis's profile image Profile Picture

Jennifer Pavey on 06 Jul 2020 00:13:33

RE: Add "monthly" as a scheduled refresh option

We only need to update our Performance Metrics monthly as the report is based on a rolling 12 months. There is no way to use the daily/weekly to make the dateset auto refresh the first day of a new month so I would have to set refresh to daily which is a waste of resources. For now I set a reminder to do the refresh. I foresee we will probably have many Power BI Reports in the future that are similar. I would think this would be an easy feature to add :)

Shawn Davis's profile image Profile Picture

Power BI User on 06 Jul 2020 00:10:45

RE: Add "monthly" as a scheduled refresh option

This should be a no brainer.

Shawn Davis's profile image Profile Picture

Power BI User on 06 Jul 2020 00:10:08

RE: Add "monthly" as a scheduled refresh option

Needs doing, have used Power Automate as a short cut and works fine.

Shawn Davis's profile image Profile Picture

dylan brown on 06 Jul 2020 00:09:54

RE: Add "monthly" as a scheduled refresh option

The PBI dev team must have been fired. Simple stuff such as this should have been introduced years ago. Please MSoft, Support your users....

Shawn Davis's profile image Profile Picture

Jonas on 06 Jul 2020 00:09:34

RE: Add "monthly" as a scheduled refresh option

Just like previous comments, I cant believe that this feature hasn't been implemented. Probably because of the license model, which are based on data consumption. MS know the need for this and by implementing that feature would mean less income probably.

It's an essential feature to have in reporting!

Shawn Davis's profile image Profile Picture

Chris Nunn on 06 Jul 2020 00:09:32

RE: Add "monthly" as a scheduled refresh option

This must be such a simple thing to introduce and yet this idea has been sitting here for years without being actioned. Please bring in this feature!

Shawn Davis's profile image Profile Picture

Celene Rudling on 06 Jul 2020 00:09:32

RE: Add "monthly" as a scheduled refresh option

Wow - this was suggested in 2015 and STILL hasn't been implemented....?! Monthly refresh is essential - I can't believe it wasn't added at the same time as Daily and Weekly was

Shawn Davis's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:09:06

RE: Add "monthly" as a scheduled refresh option

Great idea and while you are at it, please also add 'hourly' as this is a premium options but has to be added manually 24 times under daily.

Shawn Davis's profile image Profile Picture

Power BI User on 06 Jul 2020 00:08:51

RE: Add "monthly" as a scheduled refresh option

Hi , Power BI service allows only weekly and daily schedule refreshes at present , it would be useful if we have a monthly schedule on the 1st day of each month.

Thanks,