Allow Optional ‘End Date’ for Semantic Model Scheduled Refresh

[TyndaleBB]

Today, Power BI semantic models’ scheduled refresh only supports defining recurrence frequency — there’s no way to specify when a deprecated model should stop refreshing. As a result, older model versions continue consuming compute and generating confusion over which version is “current.”

Idea: add an optional “End refresh on” date picker to the Scheduled Refresh pane. When the date arrives, the refresh schedule is automatically disabled.

Key scenarios:

• Versioned models (e.g. retire Sales Model 1.0 when Sales Model 1.1 goes live)
• Phased migrations, with a defined overlap window between old and new versions
• Cost control and governance, by halting refreshes on models that should no longer run

Suggested UI details:

• In the dataset’s Schedule Refresh settings, display an optional “End refresh on” date field beneath the recurrence options
• Show a pre-expiration warning banner in the UI and send an optional notification email
• Log the automatic disable action in the refresh history for auditing

[Chris_GSD]

Also add a start date too, so that you can determine when the scheduled refreshes are to start and end. We have some Power BI reports where the data only needs to be refreshed once per year, around the same time each year. To be completely flexible, look at the SQL Server Job Scheduler, and this also allows the schedule to be repeated daily, weekly, yearly, etc, and also on a particular day of the week (e.g. every Tuesday & Thursday), and having the ability to set these too would be really useful to include.