Skip to main content

    Power BI

    Needs Votes

    Add "monthly" as a scheduled refresh option

    Vote (1036) 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)?

    Comments (171)
    Shawn Davis's profile image Profile Picture

    496dd8b1 ce93-4edd-8ecc-282c2ffc73f8 on 06 Jul 2020 00:08:08

    RE: Add "monthly" as a scheduled refresh option

    Weekly and Daily just doesn't cut it anymore. Even Reporting Services had en similar function to schedule by calendar. Please add this cause judging by the votes, it is much needed.

    Shawn Davis's profile image Profile Picture

    a8b729fb 2a42-4efe-be4a-dd6f9b05e6c9 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

    65fd9fd1 4624-4ff9-810a-263f7ba0b491 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

    3c0013f9 205e-42f8-bf7d-188d0567fc45 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

    4f203475 afde-4386-9e37-b1a767c3ee6f 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

    631ae19c a0da-475b-9e11-b0e90bce6919 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

    a3309361 99be-ea11-a812-000d3a8ddfb2 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

    5b6903e8 67c7-40bd-91ae-2f29468c150b 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

    0eee8842 f703-4c86-abf6-88137cfbb530 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

    29153aad 2bcd-4661-92c2-57aa858b980a 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