Forum Discussion
PowerBI API throttled
I am attempting to export reports for multiple clients with each multiple parameters to pdf using the PowerBIRestMethod PowerShell command.
I first loop through the clients and then for each client I try to update the parameter and export the report.
The problem is that after about 30 parameter updates I get the following error:
Invoke-PowerBIRestMethod : One or more errors occurred. ({
"code": "ActivityLimitReached",
"message": "UpdateDatasetParameters on xxx-xxxx-xxx throttled"
})
I tried upgrading the Premium SKU but this has not changed anything.
Does anyone know what the limits of this API/the Premium SKU is?
There does not seem to be any documentation on this limitation.
It clearly states here Power BI Premium capacity load, overload, and autoscale - Power BI | Microsoft Learn that your requests will be treated as second class citizens.
3 Replies
See the limitations section. Export Power BI embedded analytics reports API - Power BI | Microsoft Learn
It does not mention anything about a maximum amount of parameter updates in the documentation for the API call: Update Parameters In Group
It is also not an issue with exceeding the maximum amount of refreshes in a day (seeing as though it needs to refresh the semantic model after every parameter update API call) because the error specifically happens when I try to update the parameter; not when I try to refresh the semantic model afterwards.In the linked documentation I also find no potential issues that my export script would run into.
It clearly states here Power BI Premium capacity load, overload, and autoscale - Power BI | Microsoft Learn that your requests will be treated as second class citizens.
