Export the report into multiple sheets of same excel file

[amrutha38]

Hi,

I noticed that it's currently not possible to export data from multiple visualizations or from multiple pages into separate sheets within the same Excel file. Can we expect to see a feature like this in the near future?

Additionally, is there a way to export data while retaining the formatting of the visualizations?

Thank you.

[collinq · Accepted solution]

Hi @amrutha38 ,

When exporting to Excel, one of the issues is that your computer's Excel settings override some of the Power BI settings (like your Excel date format will override the Power BI date format setting).  Also, most other formatting is lost as well.  Pretty much only the data is exported.  There is an idea to vote for this to be changed though:  Microsoft Idea

Also, you can not currently export into multiple tabs but I found two ideas to vote for for that idea:  Microsoft Idea  and Microsoft Idea