Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Is there any solution for this? Having the same. Thank you!
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.
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.
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
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 😕
Is there any solution for this? Having the same. Thank you!
Hi, I'm getting the same issue.
Do you know how long you have to wait before your request calls are accepted again?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |