Forum Discussion
Report Builder - bursting
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.
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
4 Replies
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
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
Hi Hari, I have gone through the below link, created a flow from Power Automate but the schedule is failing and unable to get the option or process to set up the foreach. Can you please explain what is this process and how to set up in powerBi service?
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
Hi, We are in the process of transitioning Cognos report to PowerBI and most of the reports we have in Cognos is using Burst funcitonality, they burst the files on shcedule to a shared drive. I'm looking for the process to implement the same in PowerBI. I noticed you are able to achieve this by using Foreach, can you please try to explain or share the steps what is foreach nd how to implement this process? If possible, please share screenshots
