How to handle the power BI refresh time limit while having multiple refreshing report request.

[Suryakant_99]

Hello everyone,

I want to know is there any way to trigger multiple refresh request using power bi client library in a given time.

As per need, we want to trigger multiple report refresh request, but that refresh request are failed due to the Power BI client has limitation.

The error message which show in browser console - "Power bi client library failed to refresh the report because power bi report refresh has limit that 1 request(s) every 15 seconds."

So how can we handle this.

[Suryakant_99 · Accepted solution]

We can avoid that Power BI Limitation and allow to refresh report using exponential backoff technique.

Exponential backoff mechanism that waits longer between each retry, starting with a base delay (e.g., 15 seconds as per the rate limit) and increasing the wait time exponentially in case of consecutive rate limit errors. Optionally, add a random jitter to prevent the thundering herd problem.

[lbendlin]

What are you trying to achieve?  If you need real time performance, use real time datasets  (Streaming Hybrid, for example)

[Suryakant_99]

I'm trying to add bookmark and refresh the report each time a bookmark added.

This is not related to any performance issue.

We are basically rendering power bi report inside our angular application, and we are calling power bi client library to refresh the report and power bi client library throw error saying that "failed to refresh the report because power bi report refresh has limit that 1 request(s) every 15 seconds."

So, I want to know, is there any way to get rid of power bi refresh time limit ?

[lbendlin]

I'm trying to add bookmark and refresh the report each time a bookmark added.

Note that "report refresh"  and "semantic model refresh" are different things.

What you are looking for seems to be APR (automatic page refresh) and the limits for that are set on capacity level. Talk to your capacity admin.