Power BI

Under Review

Add "monthly" as a scheduled refresh option

Vote (3313)

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 (263)

Comments (263)

Alistair Wickham on 16 Sep 2020 02:43:46

RE: Add "monthly" as a scheduled refresh option

Agree with the below comments. Microsoft please make it at least as flexible as SQL Server Agent scheduling

Chris Barron on 15 Sep 2020 14:02:08

RE: Add "monthly" as a scheduled refresh option

Come on Microsoft. This is a much needed feature, as Monthly Reports are a real thing out here in the real World.

How many votes do you need? Do I need to spam my entire company to log in here and hit the button at the top?

Roy Bywater on 13 Jul 2020 23:37:46

RE: Add "monthly" as a scheduled refresh option

Monthly scheduling would be a great addition

Kim Pearson-Kime on 13 Jul 2020 23:30:48

RE: Add "monthly" as a scheduled refresh option

Definitely need more flexibility when scheduling, options like monthly/yearly etc. Also need more timing options. An option to have more than one schedule per dataset would be great so you could schedule daily Mon - Fri and once on Sunday.

Narendra Narendra on 06 Jul 2020 00:18:16

RE: Add "monthly" as a scheduled refresh option

It should required the monthly schedule

Power BI User on 06 Jul 2020 00:17:24

RE: Add "monthly" as a scheduled refresh option

Critical need as most financial reporting systems have month end processing jobs. Thus the lack of this feature does not allow for proper vetting of data between Power Bi and other internal reporting systems.

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

RE: Add "monthly" as a scheduled refresh option

Can we consider this idea to be "improve the scheduled refresh features" that can incorporate other similar ideas? As well as refresh monthly, I'd like the option to refresh some sources within a dataset at one frequency, and some at another (or not at all). Or everything yearly, fortnightly (which could probably be rolled up into this main idea by having more than one day within the monthly option). Different frequencies per day would also be nice - right now we can only differentiate between doing every scheduled refresh on a day, or none of them, there's surely some demand to have a dataset refresh frequently during the working week, but just once a day at the weekend. Or refreshing at times other than just on an hour/half hour to spread gateway loads.