Forum Discussion
API throttling limits? http response 429
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 🙂
8 Replies
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
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.
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.
