Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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:
Regards
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:
Regards
@sfog , there is similar article, check if this can help
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
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.
Hi @Seanan - thanks but neither of those are Admin APIs. See my original post for reasons why it has to be an Admin API.
No Seanan - the status is "Failed" in this API.
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.
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |