We are excited to announce a new and simple way to monitor and ensure the successful execution of scheduled refreshes on Power BI Premium capacities!
The Refresh Summaryย page in the Admin Portal is where capacity admins get an overview of all scheduled refreshes activity on their premium capacity. The page is powered by aย New REST API for refreshย monitoringย that can be extended usingย existing automation tools .
Through the Refresh Summaries page, capacity admins have visibility into:
- Scheduled refresh activity status for the pastย 7 days including error messages (in the โHistory Viewโ)
- โHot-spotโย times in the week when too many refreshes are scheduled (in the โSchedule Viewโ).
- Who are the users configuring scheduled refreshes, so that they can contact them and request changes to schedule if needed.
- Various scheduled refresh statistics for all configured scheduled refreshes (like average duration based on past 60 executions, number of refreshes per day and more)ย ย ย
Learn more about the Refresh Summary page and how to use it to ensure successful scheduled refresh execution in the Power BI Docs.
The refresh summary page is powered by the latest addition to Power BI REST APIs: the โRefreshablesโ REST APIย .
This API allows full scripting and automation against scheduled refreshes metadata. You can use Power Automate with it to take automatic action based on scheduled-refresh-related triggers, like automatically sending email notifications to admins when refreshes fail or take too long to complete.
The API exposes 3 different calls and is available for tenant admins and capacity admins:
- Getrefreshableforcapacity โ for getting refresh data for a single refreshable object (dataset)
- Getrefreshablesforcapacity โ for getting refresh data for all objects in a specific capacity ID
- Gtrefreshables โ for getting refresh data for all objects the user has access to
In this initial preview release, we included scheduled refreshes of Power BI datasets in the Refresh Summaries view and in the โRefreshablesโ API.
In future releases, we will consider adding scheduled dataflow refreshes as well as other scheduled operations likeย scheduled subscriptions of paginated reportsย and others.