topic Re: PowerAutomate ExportToFile for Paginated Reports error: You have exceeded the amount of requests in Developer

PowerAutomate ExportToFile for Paginated Reports error: You have exceeded the amount of requests

Mukesh_Patel — Fri, 31 May 2024 14:45:34 GMT

Hello,

I'm working on a Power Autmate flow that uses the "Export To File for Paginated Reports" API.

When multiple instances of the flow are triggered I get the following error at the Export To File step

"message": "You have exceeded the amount of requests allowed in the current time frame and further requests will fail. Retry in 141 seconds."

I am using a Power BI Premium Per User license.

Re: PowerAutomate ExportToFile for Paginated Reports error: You have exceeded the amount of requests

lbendlin — Sat, 01 Jun 2024 02:51:39 GMT

ok, what is your question?

Re: PowerAutomate ExportToFile for Paginated Reports error: You have exceeded the amount of requests

Mukesh_Patel — Mon, 03 Jun 2024 12:55:39 GMT

Is there a workaround to this issue or another license that does not have this restriction?

Re: PowerAutomate ExportToFile for Paginated Reports error: You have exceeded the amount of requests

lbendlin — Mon, 03 Jun 2024 13:03:20 GMT

There is not. If you have a plan to export 500 reports on a daily basis (for example) then you will have to reconsider your plan.

Re: PowerAutomate ExportToFile for Paginated Reports error: You have exceeded the amount of requests

Mukesh_Patel — Mon, 03 Jun 2024 14:08:55 GMT

I am looking at a plan to export hundreds of reports daily with ability to scale up.

Can this be achieved if I build the workflow on a different platform or is this a limitation for Power BI Paginated reports?

Re: PowerAutomate ExportToFile for Paginated Reports error: You have exceeded the amount of requests

lbendlin — Mon, 03 Jun 2024 14:01:27 GMT

An export API operation load is evaluated as a slow-running background operation, as described in Premium capacity load evaluation.

In my experience you will be lucky if you can eke out 50 exports in a 24 hour period.

Consider using other tools. Consider not doing all these exports, etc.