Paginated report - emailing to customer

[Anonymous]

Hello all,

I have created a paginated report to produce customer invoices. I currently export the results to PDF which consists of 1 file containing back to back invoices per customer ( e.g. 1 PDF file consisting of 100 pages, belonging to 50 customers, each individual customer report consists of 2 pages).

Is there a way I can send each customer's report to them by email directly from the Power BI Service when generating the report?

Each customer should only get the relevant 2 pages of the report associated to them obviously.  

I'd be grateful if you could let me know how I can achieve sending each customer their copy of the report by email, ideally as a PDF attachment in an email. Is this achievable?

Many thanks,

Alison 

[GilbertQ · Accepted solution]

Hi @Anonymous 

Yes, this is certainly possible if you are running, Power BI  premium. You can use the dynamic subscription emails. for Here are more details Create a dynamic subscription for a paginated report - Power BI | Microsoft Learn

[Anonymous]

Hi, sorry for the delay with this, 

I have tried to set this up but i think there's a problem with the license. I have Power BI Premium per user, but when I go to create a subsription i don't have the option to select the Dynamic per recipient (preview) option?

Will I have to upgrade to get this working?