How can I see a list of dataset connection refresh failures.

[DKHUghes55]

Hi Community,

I'm looking for a way to identify all of the dataset refresh errors inside our tenant.  i.e.  Those refreshes who have failed and disabled the scheduled refresh.  I need to see across all workspaces.

Any help would be greatly appreciated.

Thanks,

DKHughes55

[lbendlin · Accepted solution]

there's no magic to that.  Enumerate all workspaces (or use a list that you refresh occasionally) then for each workspace enumerate all semantic models, then for each of these fetch the refresh history details.

Note 1: make sure you grab the refreshID so you don't double count

Note 2: you can use a filter to only fetch the non-completions

Note 3: The history only holds the last 20 refreshes per semantic model. So you gotta be quick or you risk losing that history for semantic models with crazy refresh cadences.

and disabled the scheduled refresh

That's not auditable.  You'll have to count the consecutive failures yourself.

[DKHUghes55]

Hi Ibendlin,

Thanks for the information, Is this done through an REST API or through a PowerShell module?

DKHughes55

[lbendlin]

Both 🙂  The Powershell modules call the REST API internally.