Looking for Admin API to get all disabled scheduled refreshes

[sfog]

Hi

Does anyone know of an Admin API to get all disabled scheduled refreshes?

We had an outage and many scheduled refreshes were automatically disabled becaused they failed 4 times.

I am looking for an API that can list all datasets where the scheduled refresh was automatically disabled.

It has to be an admin API as I need to access all workspaces in the organisation.

I have gone through most of the Admin APIs but they all retrned refresh status "Failed" and not "Disabled" as expected.

Thanks

[sfog · Accepted solution]

Hi

I managed to implement a workaround for this.

Note that scheduled refresh can be disabled by Microsoft in two situations: (a) 4 consecutive failures or (b) the report not being used for a period of time. As a workaround, this will identify the former:

API: Admin – Get Refreshables API.

Test for the following condition:

• RefreshFailures>=4 and
• refreshType is “Scheduled” and
• status is “Failed” and
• enabled is “false”

Regards 

[amitchandak]

@sfog , there is similar article, check if this can help

https://blog.crossjoin.co.uk/2022/06/19/cancelling-power-bi-dataset-refreshes-with-the-enhanced-refr...

[sfog]

Hi @amitchandak 

Thanks for your post however I do not see anything relevant in the URL you posted. Am I missing something? 

The URL you posted refers to cacnelling a refresh and references API tools etc. 

I don't have a problem running APIs - I just cannot see an Admin API that can report what I need.

Thx

[Seanan]

Hi @sfog 

I'm not the most knowledgeable with the Admin API's but I've done some digging and unfortunately I haven't been able to find an API that can return all disabled scheduled refreshes for a workspace. 

However, I've found some Microsoft documentation pages that may be of use. Sadly it does require a bit of manual overhead.

Help1 

Help1 

[sfog]

Hi @Seanan - thanks but neither of those are Admin APIs. See my original post for reasons why it has to be an Admin API. 

[Seanan]

@sfog Apologies, would this be more useful? Help3

[sfog]

No Seanan - the status is "Failed" in this API.

[Seanan]

Ah I was hoping maybe the "enabled": true, would be of some use (If it says false then the refreshing would be disabled).

As I don't know too much about this topic, I'll leave this topic to someone with more knowledge. 

Hope you manage to find the answer you're looking for.