Export button in Power BI Report using Power Automate

[Anonymous]

Hi Team,
I am looking for the solution of export power bi report pages as pdf and send as attachment to email by using the power automate.

Flow action steps.

Here I have given all the details, for time being i am given one page info

Flow works as per power bi service account which is related to user login.

Then the file send to the respected user mail id

I have created the Power Automate button in the report.

Once you click the export button, the flow is triggered, and you will receive the output file in your email.

But the issue is,

In my report, there are several slicers, one of which is a Sponsor Slicer. As shown in the above image, "ABC" is selected as a filter in the slicer.

However, when the sponsor is changed to some XYZ, and the export button is clicked, the PDF file received via email does not reflect the updated sponsor selected values. below you can see the few slicers in my report.

Even after the export click, power automate exported pdf still gives the anthem related data only.

My Ask here is, I need to have the power automate updated and work as in when i change the slicer selection based on that the values of pdf should be reflected and exported over pdf file and send it over email.

I have added sponsor column into the power automate button visuals fields section and tried but still it didnt work.

Can anyone please guide me on how can i resolve this issue.

Thanks,

Mohan V.

[Anonymous]

Hi @Anonymous ,

Please try to add a “Refresh a dataset” action. Check if it works.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Anonymous]

Thanks for your inputs,
I have added an action ( Refresh a dataset ) before exporting the file, dataset got refreshed but there was no change as mentioned previously.

Is there any alternative one or do i need to mention filter columns into flow.

Apreciate your time and efforts on it.

Thanks,

Mohan V.

[Anonymous]

Hi @Anonymous ,

 If you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

Best Regards,

Neeko Tang

[saud968]

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!

[Anonymous]

Thanks for your inputs,
I have added an action before exporting the file, but there was no change as mentioned previously.

Apreciate your time and efforts on it.

Thanks,

Mohan V.