Skip to main content
Microsoft Idea

Power BI

Under Review

Add "monthly" as a scheduled refresh option

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

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

RE: Add "monthly" as a scheduled refresh option

I need to do something that's scheduled monthly, so this is more or less a must have for me now

Shawn Davis's profile image Profile Picture

Francois La Haye on 06 Jul 2020 00:08:01

RE: Add "monthly" as a scheduled refresh option

What are you waiting for... :( This should be an easy fix on power bi service.

I have a bunch of exec who needs dashboards and reports ran only monthly.

Many thanks

Shawn Davis's profile image Profile Picture

Arj Dhandapani on 06 Jul 2020 00:07:28

RE: Add "monthly" as a scheduled refresh option

How did the Monthly option get missed out. Until this feature is available, we need a resource to refresh date everymonth!

Shawn Davis's profile image Profile Picture

Giovanni Power BI User on 06 Jul 2020 00:07:27

RE: Add "monthly" as a scheduled refresh option

MS SQL offers many scheduling options. I am struggling to have them matched in PBI. Please add the monthly refresh option

Shawn Davis's profile image Profile Picture

Power BI User on 06 Jul 2020 00:07:13

RE: Add "monthly" as a scheduled refresh option

FYI, you could realise this pretty easily using a Microsoft Flow to trigger the refresh. That being said, this shouldn't be difficult to implement in the PowerBI service.

Shawn Davis's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:07:05

RE: Add "monthly" as a scheduled refresh option

Absolute must. Not sure why this wasn't available out of the box while daily/weekly is.

Shawn Davis's profile image Profile Picture

Heinrich Hochhalter on 06 Jul 2020 00:06:22

RE: Add "monthly" as a scheduled refresh option

Must be a very simple issue, to add. Now, to have a monthly refresh I need to run it daily. Isn't that a waste of resources?

Shawn Davis's profile image Profile Picture

Billy Moran on 06 Jul 2020 00:06:18

RE: Add "monthly" as a scheduled refresh option

Much needed. This is a big issue for a few recent report we have setup. Now someone has to be assigned to go in monthly and update each report - takes a while with tons of data and formulas behind each. And if that person is unavailable we need a backup, as the report is critical and timely.

Shawn Davis's profile image Profile Picture

Mitchell on 06 Jul 2020 00:05:40

RE: Add "monthly" as a scheduled refresh option

This would be great to have. I need my data to refresh on a specific date of the month and this is not possible by weekly selection

Shawn Davis's profile image Profile Picture

clqLoveSpace on 06 Jul 2020 00:05:26

RE: Add "monthly" as a scheduled refresh option

Any chance of a monthly refresh soon?