Export multiple sheets in report to and excel in power bi service

[shruti_jain]

Is it possible to export multiple sheets from a single report to one excel in power bi service. 

[Anonymous · Accepted solution]

Hi Shruti,

Currently, Power BI service does not natively support exporting multiple sheets from a single report to one Excel file.

However, you can achieve this by exporting each visual or table individually to Excel and then combining them manually.

Alternatively, you can use Power Automate to automate this process.

Regards,
Chiranjeevi Kudupudi

[christinepayton · Accepted solution]

Any customization as far as what goes into the Excel files and how they behave would have to be done with Power Automate. You can query a dataset with Power Automate, running multiple if you need, and then combine the query arrays into a single array, then push that to a file. It'd be easier to send it to CSV, but if you really wanted to you could get it into XLSX format... it'd probably involve for-each looping on the array for the latter, so not something to do if you have many thousands of rows. 

[Anonymous · Accepted solution]

Hi Shruti,

Currently, Power BI service does not natively support exporting multiple sheets from a single report to one Excel file.

However, you can achieve this by exporting each visual or table individually to Excel and then combining them manually.

Alternatively, you can use Power Automate to automate this process.

Regards,
Chiranjeevi Kudupudi