Naveen kumar Yelgam on 21 Jun 2021 15:21:32
as per the document After two months of inactivity, scheduled refresh on your dataset is paused.
Is the default two (2) months of inactivity to pause the refresh something that can be customized? It would be best if the default was six (6) months, that would allow all quarterly reports to be always refreshed (up to date).
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh#schedule-refresh
- Comments (1)
RE: changing inactivity to six months from two months
The blunt implementation of "pausing" (actually stopping!) a schedule based 2 months of inactivity, defined as a "dashboard or report" directly accessing a dataset, is an inadequate approach because:Any report with cadence past 2 months is likely to be paused.The cadence options do not sufficiently cater for infrequent updates which would help capacity loads given as the excuse for auto-paused schedules.When the dataset is used as a direct query source it does not register activity.This is critical for real time data where the source does not store much history and an incremental load is done.Excel as the only tool querying a dataset falls into this category too.Datasets used to isolate loads for cadence, stability or complexity are not directly accessed because linking Power BI datasets behave like direct queries and are auto-paused after 2 months.Microsoft should do better at identifying usage before imposing such a lazy automated maintenance load on administrators.