Export button in Power BI Report using Power Automate

Here are some steps you can follow to ensure the slicer selections are reflected in the exported PDF:

Ensure the Power BI Report is Published: Make sure your Power BI report is published to the Power BI service and that the slicer selections are working correctly in the service.

Update Power Automate Flow:

Trigger: Use the "Power BI Button" trigger to start the flow.
Export to File for Power BI Reports: Use the "Export to File for Power BI Reports" action. Ensure you select the correct workspace, report, and page.
Wait for Export: Add a delay or a "Do until" loop to wait for the export to complete.
Send Email with Attachment: Use the "Send an email (V2)" action to send the exported PDF as an attachment.
Dynamic Content:

Ensure that the slicer values are dynamically passed to the Power Automate flow. You might need to use the "Power BI Data" action to get the current slicer values and pass them to the "Export to File" action.
Check Permissions: Ensure that the account used in Power Automate has the necessary permissions to access the Power BI report and export data.

Test the Flow: Test the flow with different slicer selections to ensure it captures the updated values.

Here's a simplified example of how your flow might look:

Trigger: Power BI Button
Action: Export to File for Power BI Reports
Workspace: Your Workspace
Report: Your Report
Page: Your Page
Action: Delay (e.g., 30 seconds)
Action: Send an email (V2)
To: User Email
Subject: Exported Report
Body: Please find the attached report.
Attachments: Exported PDF file

Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!