Skip to main content

Power BI

Under Review

Add "monthly" as a scheduled refresh option

Vote (3284) 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 (260)
Shawn Davis's profile image Profile Picture

Sébastien De Bosscher on 04 Nov 2021 19:46:41

RE: Add "monthly" as a scheduled refresh option

First workday of the month would be better!
And weeks go from MONDAY to Sunday in Europe, not Sunday to Saturday as displayed in datepickers etc.

Shawn Davis's profile image Profile Picture

Howard Taylor on 04 Nov 2021 13:51:32

RE: Add "monthly" as a scheduled refresh option

For us to. We do not want to do this weekly as unnecessary and especially where there are big queries and this will be done numerous times over many entities and solutions. A waste of resources and money and we may have to revert to manual monthly updates and which is not ideal. So it would be helpful to extend the updates to monthly.

Shawn Davis's profile image Profile Picture

Staci Gilmore on 01 Nov 2021 15:24:27

RE: Add "monthly" as a scheduled refresh option

This would make running 72 BPI files monthly a whole lot easier!

Shawn Davis's profile image Profile Picture

Sandra Melanie Koch on 27 Oct 2021 06:34:23

RE: Add "monthly" as a scheduled refresh option

I think this should really be a basic function

Shawn Davis's profile image Profile Picture

Katerina Bila on 25 Oct 2021 09:56:50

RE: Add "monthly" as a scheduled refresh option

How does this still not exist?? That should be a basic feature, so many financial and business reports are on monthly basis

Shawn Davis's profile image Profile Picture

Yusuf Aboobaker on 22 Aug 2021 05:41:59

RE: Add "monthly" as a scheduled refresh option

I had the same issue. The workaround is to use a scheduled cloud flow on Power automate as a trigger and the use the power bi 'Refresh a dataset' action. Guy in a cube talks about this option

Shawn Davis's profile image Profile Picture

Uladzimir Huletski on 16 Aug 2021 08:26:55

RE: Add "monthly" as a scheduled refresh option

it's highly demanded feature since 2015, pls. turn it on

Shawn Davis's profile image Profile Picture

Ali Baig on 03 Aug 2021 21:06:23

RE: Add "monthly" as a scheduled refresh option

Monthly refreshes. Even refreshes based on a calendar is an option in old reporting tools like Business Objects. I am surprised this isn't available in Power BI.

Shawn Davis's profile image Profile Picture

Karen Lillystone on 02 Aug 2021 13:50:12

RE: Add "monthly" as a scheduled refresh option

Yes this agree this is a big request from us - I moved over from another reporting tool which had all these options when scheduling monthly / weekly - certain days of the week etc - even a calendar based schedule.

Some of our reports really need this - I was just surprised the feature was not available..

Shawn Davis's profile image Profile Picture

George Power BI User on 29 Jul 2021 10:16:46

RE: Add "monthly" as a scheduled refresh option

This is holding up our efforts to automate legacy reporting within our organization. Seems like a no-brainer to me. Please get this done