Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Add "monthly" as a scheduled refresh option

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)?
Status: Under Review
Comments
S_Suessenbach
New Member

We would also be greatful if a monthly refresh option or at least similar option as on the Report Server would become available! Is there any update on this idea?

fbcideas_migusr
New Member

Hello @Admin,

The idea has changed to under review over a year ago, it would be nice to see this option, which is useful for many organizations that have monthly reports.

David_Danielsso
New Member

Please give us monthly Refresh frequency

ewakol1
New Member

Yes!

daven
New Member

This would be Super useful.

Also under monthly, if it was possible to add things like, working day 4 or the first Monday / the Last Friday.

fbcideas_migusr
New Member

I currently schedule jobs to run weekly because monthly is not an option. Microsoft could lower resource consumption by making this an option. For monthly, I need options like Fist 1 and Last "


For example, some reports are needed the last Thursday of the month, other reports are needed on either the 1st or 2nd Monday of every month.

bteague
New Member

Holy moly, why is this question even needing to be asked? Why is this not available?

AdminRJaramillo
New Member

I can't believe this is still not an option. I have data that only refreshes once a month but no capability to schedule the report to only refresh monthly. It's a waste of resources. I know there have been comments from Microsoft about using PowerAutomate to trigger refreshes, but that's yet another thing for IT to have to manage. And, if we use that strategy, how am I to determine if planned refreshes actually occurred? It's unfortunate that the scheduling functionality of the service is LESS THAN the scheduling functionality of Power BI Report Server.

Robin_Pearson
New Member

I am surprised this feature was requested 9 years ago in 2015, and it's been "under review" since 10/21/2022, still no resolution. This is such a basic request, I don't get it. I have reports refreshing daily and using processing resources that I shouldn't need to account for because I can't schedule it monthly. Weekly is not an option because first day of the month does not fall in line with a weekly refresh.

fbcideas_migusr
New Member

Yes, is great.