I am using the REST API of Azure Analysis Services zu check if my tabular models have been successfully processed in the last 24 hours.
I'm doing that in a Logic App by querying all refreshes (send a GET request with /refreshes), then iterating over the response JSON and comparing the end date of each refresh with the current date.
My problem is, for my older tabular models this takes around 15 minutes since there are already 2000 refreshes in the http response. This problem will only get worse as time passes.
So therefore, my question is, if there is any possibility to only query the top X refreshes or refreshes of the last X days or something like that? Or even only get the refreshes in sorted order (i noticed they are not sorted in the JSON) so i could stop the loop after X iterations?
If none of that is possible, is there a way to "reset" the refresh history of my tabular models (aside from deleting and redeploying them)?
Would be great if someone could help me out.
Best regards, Monica