Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dynamically export pages to PDF based on slicer values

I am looking for a way to dynamically loop through values of a slicer and extract all pages of the dashboard for that value and then move on to the next value until it reaches the end of the slicer v...
Need Help
rohithkothaneth's avatar
rohithkothaneth
Icon for Resolver I rankResolver I
2 years ago

Hello @Anonymous,

I'm in a similar scenario, where I looking to export my report pages to PDF based on the dynamic slection of the filter, populate the visuals accordingly and then loop through values in the slicer list and perform the same action untill end of the slicer list.
Any luck in finding an option other than the alternate approach that you took?

 

Thanks,
Rohith

rohithkothaneth's avatar
rohithkothaneth
Icon for Resolver I rankResolver I
2 years ago

I have a solution to this issue if people are looking for one.  You can find it in the belwo post -https://community.fabric.microsoft.com/t5/Desktop/Dynamically-export-the-report-pages-to-PDF-based-on-slicer-value/m-p/3508227/thread-id/1159568#M1162164

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Rohith,

     

    I'm in a similar situation, and I'm wondering if you can achive this with only a powerbi pro license. Thank you!

    • rohithkothaneth's avatar
      rohithkothaneth
      Icon for Resolver I rankResolver I
      2 years ago

      Hi Anonymous 
      There are two options , first option you will need to premium license for the Power BI report to be used inside the Power automate.
      Second one would be, if you have an Azure tennat use the Power BI embeded capacity resource group and tag your Power Bi service workspace with the Power Bi embeded capacity resource. In this case, you can work with Power Bi Pro license.

      You can check the solution in my below post -https://community.fabric.microsoft.com/t5/Desktop/Dynamically-export-the-report-pages-to-PDF-based-on-slicer-value/m-p/3508227/thread-id/1159568#M1162164

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Thank you!