Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Export button in Power BI Report using Power Automate

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.
Mohan_GenZeon_0-1734340731130.png

Here I have given all the details, for time being i am given one page info
Mohan_GenZeon_1-1734340859191.png

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

Mohan_GenZeon_2-1734340893945.png

Then the file send to the respected user mail id

Mohan_GenZeon_3-1734340919997.png

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, "Anthem" 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.




1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

You are missing a couple of things.  

 

- your filters must be given to the Power Automate visual in Power BI. The filters must work on report level

- the running user (USERPRINCIPALNAME) must also be given to the visual as a measure

- in your flow you need to use the data that is transported from the Power BI visual to set the report level filters for the export

- in your flow you need to use the user email from the visual to set the recipient of the email.

 

 

Why can the Power BI Report users not just use the existing Export funtionality in Power BI?

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

You are missing a couple of things.  

 

- your filters must be given to the Power Automate visual in Power BI. The filters must work on report level

- the running user (USERPRINCIPALNAME) must also be given to the visual as a measure

- in your flow you need to use the data that is transported from the Power BI visual to set the report level filters for the export

- in your flow you need to use the user email from the visual to set the recipient of the email.

 

 

Why can the Power BI Report users not just use the existing Export funtionality in Power BI?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.