topic Re: API throttling limits? http response 429 in Developer

API throttling limits? http response 429

Anonymous — Mon, 30 Dec 2019 21:51:14 GMT

Hi,

We're using the API to automatically backup some of the reports we're having to S3 - which runs fine, however we're facing an response code 429 which should be throttling right?

The script loops trough our files, on every 40th file we're having a wait for 2 minutes. I'm aware of this:

https://docs.microsoft.com/en-us/connectors/powerbi/#checkalertstatus

We should be fine as they're talking about 100 calls / 60 sec. Also I checked this one:

https://docs.microsoft.com/en-us/power-bi/developer/api-rest-api-limitations

But can't find any case why we should be blocked...? We're simply using this:

https://docs.microsoft.com/en-us/rest/api/power-bi/reports/exportreport

Any hint would be highly appreciated 🙂

Re: API throttling limits? http response 429

Anonymous — Tue, 31 Dec 2019 07:39:51 GMT

HI @Anonymous ,

AFAIK, 429 error is a common error that means 'Too Many Requests' sent so that the remote server has blocked these requests.

I'd like to suggest you stop sending requests, then you can reduce send frequency and check your script if it has been invoked multiple times or works on multiple threads.
In addition,any other Power bi REST APIs running at same time? If this is a case, these limits of requests may mean total requests of same user id.

Regards,

Xiaoxin Sheng

Re: API throttling limits? http response 429

Anonymous — Tue, 31 Dec 2019 08:27:16 GMT

Thanks for your answer - but yes, I know what I means and thats why i'm asking here. "Too many requests" is kind of useless as I need to know which limitations exists so I can adjust everything. According to the public information the script should run fine but it doesnt.

This is from last night:

22:59: 8 calls

23:00: 9 calls

23:01: 18 calls

23:02: 5 calls

23:03: 7 calls

23:04: 6 calls

23:05: 10 calls

(same pattern until)

23:35: 3 calls

23:36: 6 calls

23:37: 4 calls and then fail

Any other requests are not running, except a very few for triggering refreshes. But nothing that would end up in the documented limitations. Invoked multiple times etc. is also not possible as its a simple batch script. Which also waits untail the file is completely downloaded and then take the next one.

Re: API throttling limits? http response 429

Anonymous — Wed, 01 Jan 2020 22:33:10 GMT

Hi, I'm getting the same issue.

Do you know how long you have to wait before your request calls are accepted again?

Re: API throttling limits? http response 429

Anonymous — Thu, 02 Jan 2020 03:44:37 GMT

Hi @Anonymous ,

How did the calls mean? single report or looping export all related reports? If you mean all reports, I think your request amount should multiply with exported reports count. (total request amount = report count * call times + renew access token +other triggered request)

BTW, these documents that you mentioned are most of the known information that dev team shared, if you still need more detailed information about REST API, I'd like to suggest you contact power bi team to get further support.

Regards,

Xiaoxin Sheng

Re: API throttling limits? http response 429

Anonymous — Tue, 07 Jan 2020 09:31:49 GMT

It's just the https://docs.microsoft.com/en-us/rest/api/power-bi/reports/exportreport

Access token is not renewed everytime, just every hour.

Ok, altough I wanted to avoid the support i'm giving it a try 😕

Re: API throttling limits? http response 429

riupko — Thu, 13 Aug 2020 00:34:50 GMT

Is there any solution for this? Having the same. Thank you!

Re: API throttling limits? http response 429

Anonymous — Sat, 26 Dec 2020 10:58:08 GMT

Is there any solution for this? Having the same. Thank you!

Re: API throttling limits? http response 429

riupko — Mon, 28 Dec 2020 22:46:24 GMT

I have the following workaroud and it works for my needs. Basically, I need all the reports to be backed up once weekly. I found out that PBI allows only 250 downloads per 1 hour and seems there is no way to increase this value. When exception 429 starts throwing my code goes to sleep for 1 hour and then continue doing backups.