Skip to main content
Microsoft Idea

    Power BI

    Under Review

    Add "monthly" as a scheduled refresh option

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

    Karen Lillystone on 24 Mar 2023 09:29:08

    RE: Add "monthly" as a scheduled refresh option

    Any News on this? We are going to use Power Automate but it is going to be difficult for some of the users as they will not be able to directly see the refresh.Also as someone else mentioned - what about stopping a dataset refresh? Thanks

    Shawn Davis's profile image Profile Picture

    Roberto Ayllon on 19 Feb 2023 10:34:04

    RE: Add "monthly" as a scheduled refresh option

    Fantastic idea. I would suggest also to add the option to choose whether the "scheduled refresh" should stop trying to refresh after 4 attempts.

    Shawn Davis's profile image Profile Picture

    Rehana Gafoor on 15 Dec 2022 08:35:02

    RE: Add "monthly" as a scheduled refresh option

    Hi is this request still under review?

    Shawn Davis's profile image Profile Picture

    Dale Page on 01 Dec 2022 10:59:24

    RE: Add "monthly" as a scheduled refresh option

    Capturing month end data from a number of external sources outside our direct control is absolutely essential for our C-Suite

    Shawn Davis's profile image Profile Picture

    Anil SONAWANE on 14 Oct 2022 09:20:58

    RE: Add "monthly" as a scheduled refresh option

    I don't think anyone from Microsoft is looking at these comments! And also, who on the earth from Microsoft has approved the idea of not including "MONTHLY REFRESH" option?

    Shawn Davis's profile image Profile Picture

    Pawan Vuppala on 11 Oct 2022 21:38:19

    RE: Add "monthly" as a scheduled refresh option

    How do we get this more attention?

    Shawn Davis's profile image Profile Picture

    Fraser Martens on 16 Sep 2022 14:32:44

    RE: Add "monthly" as a scheduled refresh option

    Power Automate is fine in a pinch but leads to confused/concerned users because in the workspace it appears that the dataset isn't scheduled to refresh. A monthly refresh schedule is a basic, basic feature that should have shipped with Power BI years ago.

    Shawn Davis's profile image Profile Picture

    James Bartlett on 22 Aug 2022 21:03:31

    RE: Add "monthly" as a scheduled refresh option

    BEFORE YOU VOTE: Have you tried scheduling the monthly refresh using Power Automate? I've been using Power Automate for all of my unconventional refresh scheduling needs for over a year with no problems. You should give it a try!

    Shawn Davis's profile image Profile Picture

    Michael Colbert on 22 Jul 2022 14:45:52

    RE: Add "monthly" as a scheduled refresh option

    Agree, this is needed. For now, as an alternative, you can schedule this in Power Automate, the recurrence trigger provides all the flexibility that you need.

    Shawn Davis's profile image Profile Picture

    Richard Murray on 05 Jul 2022 15:01:03

    RE: Add "monthly" as a scheduled refresh option

    Completely agree with prior requests. Monthly cadence is extremely useful.