Automatically export Power BI paginated report to excel by passing parameter

[bml123]

Hi,

I have a Power BI paginated report with a report parameter of around 150 values.
I need to run the report for each parameter and export the report into excel spreadsheet.
How do I save them automatically to my PC? Power automate is not working for some reason.
Is there a way to create data driven subscription on Power BI report server? If so, how do I achieve this so that I receive the excel attachment for each parameter in the list

[Hariharan_R]

Hi,

For this requirement, you have 3 options.

1. Create a subscription in Power BI Service manually for all 150 values - You will end up with 150 subscriptions and you can choose the format as excel.

2. Power Automate - You need to pass through all 150 values as a foreach and export the result and store it in excel. 

3. REST API - you can use Power BI rest api to export the report. You can use Powershell or anyother platfotm to run the REST API but you need to loop through for each list of value - https://docs.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group

Thanks

Hari

[bml123]

Hi Hariharan_R,

Thank you for the options.

If I have to set up subscription for all the 150 values, 

I went to Power BI service, but unable to specify the values manually in the parameter.

How do I achieve that? 

[Hariharan_R]

Hi,

You need open and run your report with the selected value in the parameter and then subscribe it. You can't change the values once you created the subscription. You need to run your report 150 times to create subscription for each value.

Thanks

Hari

Please mark this as answer if this post helps you to get what you want.

[bml123]

Hi @Hariharan_R 

Do I need admin rights to run the commands in Power Shell?