Forum Discussion

yj1111's avatar
yj1111
Helper I
2 years ago

Loop through filter and export a PDF for every value

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

4 Replies

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

    • yj1111's avatar
      yj1111
      Helper I

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

  • 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.