Loop through filter and export a PDF for every value

[yj1111]

Hi All,

I would like to create a Power Automate flow to iterate the value (100-200 values) in an excel list as a filter applied to a PowerBI page and export every report page to PDF. 

I have a PBI premium license. Does anyone have experience?

Thanks in adanvce

[KiranHosakote]

Hi @yj1111 

Even with a Power BI Premium capacity, there isn't a fully automated solution to burst reports using Power BI and Power Automate. It involves several manual setup steps to set up and ongoing manual input to maintain. 

However, if you consider third-party solutions, BI Helper at https://bihelper.tech could fulfill your needs. This tool is also listed in the Microsoft AppSource store under Business Apps – Microsoft AppSource.

BI Helper is a user-friendly SaaS application that facilitates the automated creation and distribution of personalized PDFs (with applied filters and slicers). It's secure, scalable, and requires just one Power BI Pro / PPU license.

BI Helper doesn't need Power Automate or any additional software, allowing business users to set it up and manage it with ease.

[Anonymous]

Hi @yj1111 

You can use this statement to select the pages you want to export:

https://app.powerbi.com/groups/workspaceGuid/reports/reportGuid/xxxxxxxxxx

Here is a link about how to export report by power automatic.

Export and email a report with Power Automate - Power BI | Microsoft Learn

Then you can use this expression to check mutipal-vlaues and use it in the above expression:

Use expressions in conditions in Power Automate - Power Automate | Microsoft Learn

Finally, here is a link of how to use loop in power automate:

Using loops - Power Automate | Microsoft Learn

Best Regards

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

[lbendlin]

I seem to recall that you are limited to 8 exports per day. 

[yj1111]

I tried with power automate flow. I can indeed do more than 8 exports.