topic Re: Paginated - Download Multiple excels based slicer in Report Server

Paginated - Download Multiple excels based slicer

apentyala — Sat, 01 Aug 2020 17:37:16 GMT

Hi All,

I have a business requirement whereas the user can select multiple values and when they click on export into Excel it will export individual excel files for selected values? how to do for paginated reports?

it is as a customer statement, let's say user selected 10 customers in parameters. when they click export it should be download in 10 separate excel based on customer number.

your advice or suggestions will be much appreciated

Re: Paginated - Download Multiple excels based slicer

saglamtimur — Tue, 04 Aug 2020 08:03:53 GMT

You can not download multiple Excel files, instead you can download single Excel file containing multiple sheets for each customer. Please refer to this thread and find my solution

https://community.powerbi.com/t5/Desktop/Power-BI-Report-Builder-Report-having-multiple-sheets/m-p/1141742

If my post solved your problem, mark my post as a solution to help others to quickly find it and also please give it a 👍