How to create different automated PDFs from single report

[Dave1972]

Hi All,

I have a PBI report in PBI service with 10 pages/tabsheets. I would like to generate from that report each day 3 different PDF reports to share with different people. Report nr 1 holds from the report tabsheet 1, 2, 3. Report nr 2 holds from the report tabsheet 1, 5, 6, 8, 10. Report nr 3 holds from the report tabsheet 1, 2, 4, 7, 8. 

I know that when you move to a PPU user the export full report under subscribe is activated vs Pro licence, but then you can only exclude hidden slide and will generate a pdf report with all 10 slides (full report).... 

How can this be done from single report....?

1) Should you be on Premium per User licence or can this be realized with Pro licence also?

2) Should 3 receipants all have a PBI licence and if so what sort of licence or can you also email to people in company that do not have access to PBI...?
3) Or should I from that single report create 3 different reports that hold the only specific tabsheets per report as listed above and generate pdf under subscribe with full report option?

Thanks for advice....

[Dave1972]

Thx so much kalyj. Appreciate this and understand it. Thx 

[v-yanjiang-msft · Accepted solution]

Hi @Dave1972 ,

According to your description, I'm not clear what "under subscribe" means, export to PDF function is under the Export tab.

---

I know that when you move to a PPU user the export full report under subscribe is activated vs Pro licence

---

Here's my test about your problem.

1. By my test, a Premium Per User licence can export to PDF, but a Pro licence can't.

2. If you want to share the PDF to users, the receipants can view the PDF with no PBI account, it just like a normal PDF, not a pbix file.

3. On the export page, there is a option "Only export current page", you can select it to only export the current page, otherwise export all pages. The specified multiple pages could not be exported.

Best Regards,
Community Support Team _ kalyj

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