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
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Anonymous Thanks for posing your solution, and apologies for the very late reply. I have tried all of these things, but I still have not got this working yet. When I try to generate a Power BI report using a filter in Power Automate, it either gives an error that the criteria is not recognized or the report simply never arrives in my email. I have a temporary solution in place now until a more permanent solution is found.

    • Esmat86's avatar
      Esmat86
      New Member
      4 years ago

      Hi Amper! Would you please share your temporary solution? 
      I'm looking for something very similar to your case. Every month I pull around 100 pdf from specific slicers so it will be tremendously helpful if I can get a fully or semi automate solution.   

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Esmat86 In my case, I decided to create summary dashboards with the high-level information that did not require page breaks and export them to PDF and post to a Teams directory for consumption. Within the PDFs I have links to an expanded form of the reports on the Power BI service that is hosted on an internal server. That way, the audience that is sufficed by summary reports need not wade through pages of data, but has a high-level summary. Then the audience that would like to audit the underlying data can follow the links from the PDF docs to the service and do their analysis there.

         

        I hope this helps.

         

        Cheers!