Forum Discussion
Helper IIICreate Dashboard for refresh failed datasets in Power BI Service
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.
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.
1 Reply
- edhans
Community Champion
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.