Skip to main content
Microsoft Idea

Power BI

Needs Votes

Indicate Who, Why, and When Scheduled Refresh was Disabled or Edited

Vote (4) Share
Todd McDermid's profile image

Todd McDermid on 18 Mar 2021 15:43:17

Scheduled refresh on a Power BI dataset can be altered through at least four methods:
1. The owner manually disables the refresh schedule.
2. The owner manually alters the refresh schedule.
3. A 3rd party alters the refresh schedule through API calls.
4. The service disables the refresh schedule due to multiple refresh failures.

Especially given the recent Azure Active Directory failure, the current configuration(s) in PowerBI are not sufficient to manage scheduled refresh changes. (The outage on March 15 caused refreshes to fail, but emails were not sent because email couldn't authenticate either.) If/when an administrator encounters a dataset with scheduled refresh settings other than what they expect to see... they have very little information to work with to confirm or contradict their impression.

Scheduled refresh settings could be decorated with messages such as:
"Scheduled refresh was disabled on 2021-03-15 16:42 by PowerBI due to multiple refresh failures"
or "Scheduled refresh was disabled on 2021-03-16 09:15 by todd.mcdermid@abc.net"
or "Scheduled refresh was altered on 2021-03-17 12:18 by todd.mcdermid@abc.net"

This would provide much more context on the configuration status of the scheduled refresh.

Comments (1)
Todd McDermid's profile image Profile Picture

Andy Seres on 24 May 2021 16:28:11

RE: Indicate Who, Why, and When Scheduled Refresh was Disabled or Edited

At the very least, it would be helpful to get an alert or mail indicating that it has been disabled.