I'm having an issue exporting a very simple paginated report with no datasource (essentially just a dummy report to use for testing the API). I can export the report just fine to PDF on the first request, but then it seems I need to wait 3+ minutes before I can send a second request.
I'm using the code example straight from the Microsoft site for exporting paginated reports to PDF: https://learn.microsoft.com/en-us/power-bi/developer/embedded/export-paginated-report
The first time I call the function to export it works very quickly (1-2 seconds) and I have the exported report. If I try and make a second call to the very same report within 3 minutes of the first call it hangs on this line for a couple minutes:
var export = await _powerBIClient.Reports.ExportToFileInGroupAsync(groupId, reportId, exportRequest, stoppingToken);
Then it comes back with an error "TooManyRequests". We're using a PowerBI Premium Per User licence to acquire the token for the PowerBI client. Everything i've seen online says you should be able to do up to 120 requests a minute. I can't even do 2
If I wait 3 minutes before making a second request, it works again, albeit not as fast as the first request. I'm assuming if i waited 10 minutes, eventually the next request would be completed quickly again. Scratching my head on this one - I can't find examples of anyone being throttled like this online.
Was able to confirm with an MS PowerBI support engineer that with a premium per user license you are limited to 1 request every 5 minutes for exporting paginated reports. This information can also be found here (I missed it - other articles alluded to a 120 request / minute limit)
The engineer said there are requests in to have this changed. I'm not sure how they expect people to adopt power BI, forcing them to by at least a P1 capacity at $60k/year to export some reports. I can do all of that basically for free with SSRS right now.