cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
apmer
Frequent Visitor

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 values. The closest I have been able to find so far is Play Axis dynamic slicer however I do not see a feature to run this on command via Power Automate flows.

 

The scenario is like this:

 

* I have 4 pages in my dashboard, the first page being hidden and containing only slicers and an execute button

* The execute button would be triggered from Power Automate flow to start the loop process

* The loop process will apply the filter values in sequential order and extract the 3 visible dashboard pages to PDF and save to the directory that is specified and send the dashboard to the contact that corresponds with that slicer value.

* When the end of the slicer values has been reached, the Power Automate flow will end

* The execute button could also be invoked manually if Power Automate is not preferred

 

I have read previously online that either R script or M formulae can be used to loop through filter values and extract to PDF, however I have not been able to find this documentation for a couple of years.

 

If anyone has done this type of reporting, your input is much appreciated.

 

Thanks,

Aaron

7 REPLIES 7
BipinLala26
Regular Visitor

Did you find the solution @apmer ?

I was also looking for something similar, I have a slicer on Page 1, which I use for page navigation. Only those pages get filtered/populated in the slicer for which some data exists, and then selecting the page in the slicer and using a button helps me to navigate to that page.

Now, I want to generate a PDF of only those pages that get populated in the Page Navigation slicer. 

@BipinLala26 I have not found a solution for this and ended up going a different route from Power Automate altogether. My alternate solution is not optimal, but I had to make a quick decision so I created multiple dashboards to suffice for now until a more permanent solution is found.

 

Apologies that I do not have a better answer at this time. If I find the solution that we are looking for, I will gladly post it back here. 

RicoZhou
Community Support
Community Support

Hi @apmer 

I find some offical blogs about export report by Power Automate flow. I hope they could help you.

For reference:

Export and email a Power BI report with Power Automate

Trigger a cloud flow from any Power BI report

Trigger flows from Power BI reports

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickl

apmer
Frequent Visitor

@RicoZhou 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.

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.   

apmer
Frequent Visitor

@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!

Thank you! this is a brilliant way but unfortunately, I can't apply that in my case.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!