Answered

Dynamically export the report pages to PDF based on slicer value which is driving a Power Bi report

(0) Share

Report

Posted on by RohithKothaneth

Hello,

I have a Power BI desktop report which is driven based on a column value "Client name" within a "Customer" table. Here the same column value is used as a slicer to populate visuals in the remaining pages of the same report. Basically I'm trying to dynamically loop through the values of this slicer, populate automatically the visuals in remaining pages accordingly based on the value selected and extract all report pages for that value into a PDF file and drop them to a sharepoint site and then move on to the next value until it reaches the end of the slicer values. I'm using Power Automate to export the report in the PDF format, but haven't found a solution yet.

These are my report criteria's

* I have multiple pages in my Power Bi report, the first page contains the slicers and an Power Automate execute button.
* Would want the value to loop through and apply the filter values in sequential order and extract the report pages to indivual PDF for the selected slicer value and drop to a SharePoint site or folder specified.
* Power automate flow will need to end when the slicer value has been reached.

Could anyone please share the steps needed in the Power automate flow to achieve this scenario, your input is much appreciated.

Thanks,
Rohith

Categories:

Power Automate Desktop

I have the same question (0)

All responses (14)

Answers (1)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @RohithKothaneth

What is this PowerAutomate Execute button ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
RohithKothaneth 32 on at

Like (0)

Report
Copy link

Link copied!

Hi @Nived_Nambiar
I mean the power automate button "Run Now" button hat can be added to the Power Bi desktop report.

Thanks,
Rohith

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @RohithKothaneth

Ok I haven't worked with interface of Power BI Desktop interface before. But i got the idea behind your question.

The automation process should follow a set of sequence which you can use how you are doing same things manually.

For example, see below steps

1. First use launch application to launch the Power BI Desktop application.

2. Navigate to Power BI Report (not sure whether this step should be required)

3. Try to capture values from slider and loop through each with below steps :

3.1. Use click action (with some logic) to move the slider to desired value

3.2 . wait for report pages to populates with graphs/visuals

3.3 . Export the report page to pdf format. [ use same approach of UI Automation on how you do things manually]

These all steps should be doing actions from UI Automation sections in Power Automate Desktop.

Since it is a kind of general problem i could not help directly with overall flow here since i haven't explored UI OF POWER BI Desktop before but can help with specific issues you may face while automating this process.

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
RohithKothaneth 32 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Nived_Nambiar for the update.
I have seen options were we pass in the values to the power automate visual and it can be used to generate the PDF version based on the selected slicer.
But in my case, I want to dynamically pick the slicer values and refresh the visual and generate PDF version of the repot, then pick the second value dynamically from the slicer list and refresh the visual accordingly and generate PDF version of the report for the new data that got refreshed and so until we end up to the end of the values in the slicer visual. How to achieve this without manually selecting the slicer value on the report side?

Below videos helped me to understand when we manually select a slicer value,
https://www.youtube.com/watch?v=zqShl3wuWRk
https://www.youtube.com/watch?v=lWu4n-ODe4U&list=PLDz00l_jz6zze26MVT-0YV7qcjismMFFo&index=5

But in my case, i want the slicer selection to happen automatically and instead of having to trigger power automate manually, have it based on a recurrence method,

Thanks,
Rohith

Was this reply helpful? Yes No
Verified answer

RohithKothaneth 32 on at

Like (0)

Report
Copy link

Link copied!

I have a solution to this issue I was facing.
when I added the filter column to my power automate visual, i can use the value inside the power automate, but when i want the same filter values to go through a loop and apply back to report so the visuals in the pages changes accordingly for me to export is where it was not working. Every time I loop through the list and try to apply different value to generate the visual and when tried to export the report into a PDF, the report output comes with the default selection and doesn't gets changes based on the filter value that i apply through power automate.
This was solved after i had set the slicer NOT to have a mandatory "Single selection" turned ON. Once I remove that, I was able to successfully test this by passing filter value as a header in the URL. Same was dynamically generated in Power automate flow and passed within the filter parameter section for the "Exporting a PDF of the PBI report" connector in Power automate.

--Used this below URL in the reportlevelfilter in the PBI connector.
https://app.powerbi.com/groups/******/reports/******/ReportSection*****?filter=<Table name>/<column name> eq '<column value>'

Was this reply helpful? Yes No
danielcosuagwu 4 on at

Like (0)

Report
Copy link

Link copied!

Hi @RohithKothaneth I am currently struggling with similar issues. I have a power Bi report that I have published. My report has list of employees that belong to different departments. Also, the report page has two slicers (Employee name and Employee Dept).

My requirement is to create a flow that will dynamically filter this report page using the slicers, export the page as a pdf. I want this to dynamically happen until the end of the employee names.

Please how did you solve yours? I need help please.

Thanks

Daniel

Was this reply helpful? Yes No
RohithKothaneth 32 on at

Like (0)

Report
Copy link

Link copied!

Hi @danielcosuagwu
You can achieve this easily by selecting the columns to the Power automate widget (in your case Employee name and Employee Dept) and then using those values in the loop inside the flow.

Sample example of the flow would look like this, here I had passed a single value "AccountName" which in your case can be two different column values. After that pass these column values as filter into the "Export the file for Power Bi reports" connector under "ReportLevel Filter" section.

Thanks,
Rohith

Was this reply helpful? Yes No
danielcosuagwu 4 on at

Like (0)

Report
Copy link

Link copied!

Thank you @RohithKothaneth for responding. Even though I am new to power automate, I will give it a shot to see how it far I could go with this.

Was this reply helpful? Yes No
SSVRAJESH 12 on at

Like (0)

Report
Copy link

Link copied!

Hi Rohith,

My requirement is exactly match with my need.
I go through the below video and i achieve the same
https://www.youtube.com/watch?v=zqShl3wuWRk

but,

I want to dynamically pick the slicer values and refresh the visual and generate PDF version of the repot, then pick the second value dynamically from the slicer list and refresh the visual accordingly and generate PDF version of the report for the new data that got refreshed and so until we end up to the end of the values in the slicer visual. How to achieve this without manually selecting the slicer value on the report side?

Can you help me on this.

Was this reply helpful? Yes No
SSVRAJESH 12 on at

Like (0)

Report
Copy link

Link copied!

How to achieve this without manually selecting the slicer value on the report side?

I want to dynamically pick the slicer values and refresh the visual and generate PDF version of the repot, then pick the second value dynamically from the slicer list and refresh the visual accordingly and generate PDF version of the report for the new data that got refreshed and so until we end up to the end of the values in the slicer visual.

Was this reply helpful? Yes No