topic Push'ed refresh fail with message: "too many refresh" but there is less refresh than limit?? in Developer

Push'ed refresh fail with message: "too many refresh" but there is less refresh than limit??

Bokazoit — Thu, 25 Jan 2024 10:16:18 GMT

I update my datamodels in a sequence where I update my data through stored procedures and after that I refresh the data by pushing the refresh.

But from time to time, not always, it says the refresh has failed due to too many refreshs, but it has only been refreshed 7 times. In the settings I have set the refresh option on the page to local time, but it looks as if the model refresh is counted by a different time than my local time setting. And another thing is that it sometimes seems as if a pushed refresh that fails (for not so obvious reasons) also count as a refresh (but not always) even though the fail is due to external things regarding Microsoft, because a retry shortly after lets the refresh complete with no errors.

So have anyone experienced this before and what was the solution?

Re: Push'ed refresh fail with message: "too many refresh" but there is less refresh than limit??

lbendlin — Fri, 26 Jan 2024 01:02:57 GMT

Please provide more details. Is that on a Shared or Premium capacity? What do you mean by "push"? Are you initiating the refresh manually in the service or via the API or via XMLA?

Re: Push'ed refresh fail with message: "too many refresh" but there is less refresh than limit??

Bokazoit — Wed, 31 Jan 2024 08:46:07 GMT

We use Pro version. We refresh the reports through API (that is a push in my mind 😊)

Re: Push'ed refresh fail with message: "too many refresh" but there is less refresh than limit??

lbendlin — Wed, 31 Jan 2024 13:27:14 GMT

Yeah, no. What you do is calling an API and telling it to do its thing. A push is when you supply the actual data that needs to be added to the dataset

Re: Push'ed refresh fail with message: "too many refresh" but there is less refresh than limit??

Bokazoit — Wed, 31 Jan 2024 13:31:31 GMT

Thanks for the correction, but did not help me closer to a solution 🙂

Re: Push'ed refresh fail with message: "too many refresh" but there is less refresh than limit??

lbendlin — Wed, 31 Jan 2024 13:43:07 GMT

Use the tenant audit log to see how many refresh requests your process actually made.

Re: Push'ed refresh fail with message: "too many refresh" but there is less refresh than limit??

Bokazoit — Wed, 31 Jan 2024 13:54:21 GMT

We did and it only use 7 and we have 8

Re: Push'ed refresh fail with message: "too many refresh" but there is less refresh than limit??

lbendlin — Wed, 31 Jan 2024 14:21:29 GMT

Check each of the requests. Each of them can retry up to three times.

Re: Push'ed refresh fail with message: "too many refresh" but there is less refresh than limit??

Bokazoit — Fri, 02 Feb 2024 06:57:53 GMT

We never get to that much retries...