topic Re: API throttling limits? in Developer

API throttling limits?

DucJanssens — Mon, 09 Dec 2024 16:22:51 GMT

Hi,

We're using a wrapper to call different tables in our Power BI instance, and see that there are throttling limits being implemented.

In older threads I see that there used to be documentation about the limitations of the API. See for example:

https://community.fabric.microsoft.com/t5/Developer/API-throttling-limits-http-response-429/m-p/886470

But any link to that documentation now links to the following page, which only contains a vague section about throttling:

https://learn.microsoft.com/en-us/rest/api/power-bi/

As such, I have several questions:

1. What is the limit per hour/minute/second on the POST /ExecuteQueries endpoint in Power BI? That is the following endpoint: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries

2. Can this limit be adjusted in any way, shape or form?

3. Is this limit measured per user, per workspace, per dataset, per table, per IP address....? What basis is used?

Many thanks in advance!

Re: API throttling limits?

Anonymous — Tue, 10 Dec 2024 08:31:10 GMT

Hi @DucJanssens ,

As far as I know, Power BI doesn't seem to support increasing Rest API usage limits.

Power BI uses throttling to maintain optimal performance and reliability. To prevent overuse of resources from single users, Power BI limits the number of API calls within a time window per user.

When a user sends a number of requests that exceeds a predetermined limit during a time window, Power BI throttles any further requests from that user for a short period.

Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn

For API POST request limitations you can check the following link:

Power BI Rest Api Limitations - Microsoft Fabric Community

powerbi-docs/powerbi-docs/developer/automation/api-rest-api-limitations.md at live · MicrosoftDocs/powerbi-docs · GitHub

This is the related document, you can view this content:

Power BI REST APIs push semantic model limitations - Power BI | Microsoft Learn

Datasets - Execute Queries - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: API throttling limits?

DucJanssens — Tue, 10 Dec 2024 08:47:06 GMT

Hi @Anonymous ,

Thank you, this helped. I indeed see in the last URL:

There's a limit of 120 query requests per minute per user, regardless of the dataset that's queried.

We already saw that the response header of the API call indicates using a retry-after header how long to wait until the next call. Let's hope that these limits are not regularly hit.