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,
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