Skip to main content

Power BI

Needs Votes

Add "monthly" as a scheduled refresh option

Vote (1036) 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)?

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

5042dd64 61c5-ea11-a812-000d3a8ddfb2 on 13 Jul 2020 23:37:46

RE: Add "monthly" as a scheduled refresh option

Monthly scheduling would be a great addition

Shawn Davis's profile image Profile Picture

e797d9aa 5fc5-ea11-a812-000d3a579c38 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.

Shawn Davis's profile image Profile Picture

9cf0ee02 5b06-4455-bed8-7b224c896529 on 06 Jul 2020 00:18:16

RE: Add "monthly" as a scheduled refresh option

It should required the monthly schedule

Shawn Davis's profile image Profile Picture

3d8ac673 02a6-42ca-bf03-aa0afd5e53b9 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.

Shawn Davis's profile image Profile Picture

a8b729fb 2a42-4efe-be4a-dd6f9b05e6c9 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.

Shawn Davis's profile image Profile Picture

d380f451 fd97-4082-825d-6c36055c2bf7 on 06 Jul 2020 00:16:58

RE: Add "monthly" as a scheduled refresh option

More refresh timing functionality such as this would be great. Thanks.

Shawn Davis's profile image Profile Picture

19e3f4ef f4b3-4997-ab61-bcf93a1fa109 on 06 Jul 2020 00:16:15

RE: Add "monthly" as a scheduled refresh option

This is a much needed refresh option!

Shawn Davis's profile image Profile Picture

49fa5858 3055-4504-9f7d-68ac48e0ba41 on 06 Jul 2020 00:15:09

RE: Add "monthly" as a scheduled refresh option

This is pretty sad this basic feature isn't present 5 years later. Let's get this off the backburner please

Shawn Davis's profile image Profile Picture

d0f40f39 9b72-4760-b1af-e537d9cbebdb 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

a31f6fe5 fccc-40ce-9798-05cfdd15585a 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 :)