Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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.
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.
Hi Ibendlin,
Thanks for the information, Is this done through an REST API or through a PowerShell module?
DKHughes55
Both 🙂 The Powershell modules call the REST API internally.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
37 | |
32 | |
25 | |
24 |
User | Count |
---|---|
37 | |
29 | |
23 | |
21 | |
17 |