Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
Solved! Go to 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
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
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
87 | |
65 | |
50 | |
45 |
User | Count |
---|---|
217 | |
88 | |
81 | |
65 | |
56 |