Forum Discussion
Solved
Retrieving scheduled refresh events using the Power BI API
Hi, We have a requirement to identify failed refreshes in the Power BI service programtically so that we can setup alerts. I'm using the following PowerShell code: Connect-PowerBIService...
Ok thanks, i'll give that a go this week and accept the solution if it works.
Hi,
Yes I've seen that you can obtain the refresh history for each dataset. The issue is we already have over 1200 workspaces with several datasets that have auto-refresh switched on. I am looking for a solution that doesn't require us to loop through every workspaces and dataset as it can be slow. Activity events seems to get us close, I just don't understand why scheduled refreshes aren't included in the response.
Regards
If you have Log Analytics Intergration setup you can look at the command event for the refresh and get the status (succeeded/failed)