Export subreports to multiple excel

[mchan]

I have three paginated report templates that needs to be run per client but they all share the same parameter, a product list for the month.
Currently I export each report to excel and I get each client's report in seperate tables, thus I end up with three excels.
Is it possible to somehow use the three reports as subreports so I can get all three reports in one excel for each client but still achieve the same excel result where each client has it's own tab?

[Anonymous · Accepted solution]

Hi  @mchan ,

You can use DAX Studio to export tables to CSV files from Power BI Desktop. Go to Advanced > Export Data and choose CSV Files, then follow the steps in Export Data Wizard. This will export tables into separate csv files. You could use other tools or methods to combine them into multiple tabs of the same excel workbook.

This is the related document, you can view this content:

https://community.powerbi.com/t5/Desktop/Combine-multiple-excel-files-into-one/m-p/76515

https://community.powerbi.com/t5/Power-Query/Export-data-from-All-visuals-at-once/td-p/1084432

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.