Export to PDF for each filters at a time

[pallavi_r]

Hi Everyone, 

I have a report with a detail page and it has filter with 80 drop down values. I want to export it to PDF for each dropdown values. Is there a easy way out to export it for all the dropdown values (Power Automate option is out of question). 

At this point of time, we are just using Power BI desktop option to export as pdf. Can anyone has better suggestion / workaround to achieve this with power bi desktop only.

We want to export it for all the filters at a time.

Please help me with your approach on this.

Thanks,

Pallavi

[KiranHosakote]

Hi @pallavi_r 

If you are open to using third-party solutions, BI Helper https://bihelper.tech may meet your requirement.

BI Helper is a popular and easy to use SaaS application that automates the generation and emailing of user-specific PDFs (with filters and slicers applied). It is secure, scalable and works with a Power BI Pro / PPU license. It doesn't require Power Automate or any other add-ons. 

[pallavi_r]

Thanks @vanessafvg  @Anonymous  for your reply. I just wanted to confirm if there is any other way in Power BI desktop. Thanks for confirming. Thanks

[Anonymous · Accepted solution]

Thanks for the reply from @vanessafvg , please allow me to provide another insight:

Hi @pallavi_r ,

Unfortunately, without using Power Automate or a similar automation tool, the options in Power BI Desktop are limited to more manual or semi-automated methods.

The best way to do this in Power BI Desktop at this time is to use the Settings bookmark and then manually export the report as a PDF.

Best Regards,
Adamk Kong

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

[vanessafvg]

may i ask why you need to do that?

it requires premium but have you considered going power bi paginated reports?  i am sure that would solve the issue.