Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
DKHUghes55
Helper I
Helper I

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

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

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.