Create Dashboard for refresh failed datasets in Power BI Service

[likhithar]

Hello All,

         I have 2000 Datasets and I scheduled refresh for all those datsets.If any of the datsets refresh fails I want to get a notification(Not to Mail).Want to see which datsets are failed and why it was failed(With Error Message).I want to create a dashboard with all the statuses of the refresh of all the datasets.Is it possible to achieve this scenario.If Yes,How to do that??And we have Premium Capacity and Datasource is DB.

[edhans · Accepted solution]

You'll need to use PowerShell with the REST API. Datasets - Get Refresh History - REST API (Power BI Power BI REST APIs) | Microsoft Docs has the exact function that will tell you if a refresh succeeds or fails. It will dump that to a JSON file which you can then consume in a Power BI Report.