Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

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.

1 ACCEPTED SOLUTION
Hariharan_R
Solution Sage
Solution Sage

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

View solution in original post

4 REPLIES 4
Explore
New Member

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

Hariharan_R
Solution Sage
Solution Sage

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

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

Anonymous
Not applicable

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.