Export to excel with multiple Sheets

[Shivayogi123]

Hi Team,

Do we have any option where we can export to excel with multiple sheets.

Each sheets will contain different columns in each sheet.

Any idea or link will be appreciated.

Thanks

Shivayogi

[Anonymous]

Hi @Shivayogi123 ,

Do you mean export data feature? If yes, currently it only support select one visual and export the data into one sheet of the excel file. Do you want to export one visual data to excel file and divide the data into different sheets of excel file? Or export all of the visuals in report page to different pages of excel file at the same time? Could you please provide more details on your requirement? Thank you.

Best Regards

[ShreyasB]

Hi, Thanks for ur reply. I want to export all the required columns into one excel sheet and then split that sheet into multiple sheets. Thanks Shivayogi

[Anonymous · Accepted solution]

Hi @Shivayogi123 ,

You can refer the following official documentation to export data into excel file, and the data will only be exported in one sheet of the excel. If you want to split them into multiple sheets, it is required to handle with it by manual. Currently Power BI doesn't support this feature. You can raise a new idea and add your comments there to make this feature coming soon.

Export the data that was used to create a visualization

Best Regards

[ShreyasB]

Hi, Thanks for ur reply. I want to export all the required columns into one excel sheet and then split that sheet into multiple sheets. Thanks Shivayogi