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

[lbendlin · Accepted solution]

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?