Forum Discussion
Report Builder - bursting
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