Requirement Email the PDF file from the Paginated report to the user when they click on the button in Power BI.
Architecture implemented: Created a Paginated report with 6 parameters. I embedded this paginated report into Power BI using the paginated visual. In this Power BI report, the end user will configure the parameters to be applied for the paginated report. Once all the parameters are applied, they will click on the apply changes to preview the Paginated report. Once satisfied, they will hit on a Power Automate button so that all the parameters will be passed into the Power Automate “Export To File for Paginated Reports” flow; from here, the PDF file is generated and emailed to the user who clicks the button.
Problem: When multiple users click on the button at the same time, it executes the flow in a queue, which delays the generation of the PDF file and impacts the usability of the report. The Power Automate flow is showing 429 errors and saying a retry occurred.
Attaching the error screenshot.