How to can we filter all reports their refresh status failed

[adnankabina]

Hello guys,

on my workspace there are more than 200 pbi reports. Some time it fails to refresh data due to database issue.  Most of the time it turns off refresh button. I want to check every day which file is not refreshd or has some error. I have to do one by one. Is there any filter it can show all failed ones. I can filter all database but I want only who are failed to refresh.

[cassidy]

You might find some options with the REST API https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history

I use Power Automate to scan for failed Datasets and do a certain action.  However, I think you are saying you have 200 Datasets which is way more than I know how to manage.  Is there any opportunity for your reports to come from fewer Datasets intstead of 1 Report : 1 Dataset?  For example:  I have 200 reports and 1 Dataset, so if the Dataset fails then it is only 1 issue to resolve.

[adnankabina]

Thanks for your link. This might work but I do not know where to run this this code. 

{ "value": [ { "refreshType": "ViaApi", "startTime": "2017-06-13T09:25:43.153Z", "endTime": "2017-06-13T09:31:43.153Z", "serviceExceptionJson": "{\"errorCode\":\"ModelRefreshFailed_CredentialsNotSpecified\"}", "status": "Failed", "requestId": "11bf290a-346b-48b7-8973-c5df149337ff" } ] }