Skip to main content

    Power BI

    Under Review

    Add "monthly" as a scheduled refresh option

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

    David Carter on 10 Dec 2021 00:32:08

    RE: Add "monthly" as a scheduled refresh option

    I need to be able to refresh datasets for some of my reports on the 9th of every month.

    Shawn Davis's profile image Profile Picture

    Cassie Peat on 07 Dec 2021 01:59:34

    RE: Add "monthly" as a scheduled refresh option

    Hi Microsoft, it appears that this has yet to be considered critical. I'm in the process of reviewing the source of reporting for the entire organisation and we need end of month reporting.
    This has effectively rendered Power BI as not fit for purpose.
    The fact that this doesn't have this is crazy. We don't have the resourcing to be manually updating reports consistently. When can we get an ETA on this?
    Sincerely,
    Frustrated Power BI User

    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