Report Builder - bursting

[mohinderbabu]

Hi everyone,

I have built a report using power bi report builder and want to generate multiple pdfs for each partner (200+). I have created a parameter for the partner. How do I automate the report generation inb pdf for all the 200+ partners and save in local drive.

Thanks for your inputs in advance.

[Hariharan_R · Accepted solution]

Hi,

There are 3 different options.

1. Manual - You can setup a subcriptions in Power BI service by opening the report with each partner and create a subscription.

2. Power Automate - Power Automate has "Export Pginated Report" action so using that you can build a flow with foreach and can automate. - https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-automate-paginated-integration

3. Power BI REST API - Using Power BI REST API, you can get the result. You can use PowerShell or any other application to run the REST API - https://docs.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group

Thanks

Hari

[mohinderbabu]

Thanks Hari, I was able to acheive it using Foreach. Apprecaite your resposne.

Couple of blogs which I referred:

https://blog.coeo.com/how-to-generate-your-power-bi-reports-with-power-automate

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-automate-paginated-excel-sharepo...