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

[Mukesh_Patel]

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.

[lbendlin]

ok, what is your question?

[Mukesh_Patel]

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

[lbendlin]

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.

[Mukesh_Patel]

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?

[lbendlin · Accepted solution]

• 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.