Skip to main content

    Power BI

    Under Review

    Add "monthly" as a scheduled refresh option

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

    Martijn Polfliet on 02 Dec 2021 12:29:06

    RE: Add "monthly" as a scheduled refresh option

    Wow... this is ludacris, something so simple... how can i not select every Nth wednesday of a month to refresh...

    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..