Export data to Excel

It would be really nice to have both visuals and its data of the report exported to Excel.

Duplicate of https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13224069-export-excel

Unfortunately MS closed 13224069 without reading the details. Users are asking for more than a .csv file. The use case calls for exporting data from the Matrix with filtering and formatting applied. Please keep voting for this Idea to keep the request alive.

For more export limit and to be able to export directly to Excel from PBI Embedded, please vote on the idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19741078-export-to-excel-from-powerbi-embedded

Exporting from Matrix table to excel gives us just the flat table and we lose subtotals etc. It will save so much time for us if it exports in the same format as Matrix with subtotals etc. We now have to create another pivot table in excel to mimic the matrix visual . Our Senior executives cannot do this and it is frustrating because we have to recreate in excel and send it to them by email .Please fix this. Many Thanks !

This feature exists in the on-line version. Why not to have put back it in the version PowerBI desktop report server? Thanks

Is it really already available in Power BI service? It doesn't appear to be.

This is a critical need to be able to Export Data to Excel as a matrix. If the visual in Power BI.com is a matrix that is 20 rows by 5 columns, then the Export Data should display the data in Excel as 20 rows by 5 columns.

This is not supported in the Power BI service. We would like a real export that matches what is on the screen without having to re-format. Tableau has this.

Its not simply that you cannot export to excel, whether on the desktop or online service. Its that the export itself is completely - lets be plain here, pathetic. When you export, there is not option to just export that the data in the graph that the user is actually looking at. And the problem is not just that the user would have to have the pivot skills (and the time) the recover the data in the graph/table he seeks, its that in MANY cases, it will be IMPOSSIBLE for the user actually recover the data. This will happen in any case where the visual contains a ratio - e.g. a growth rate. In that case, the current export shows the growth rate across every split in the fields you have on the graph/table axis/columns. But you cannot "sum up" a growth rate using a pivot. You have absolutely no way of getting a simply growth rate from an export!!!! I have had to create entire new sheets in which I have reams of tables that only have one field in the axis. Its really essential. SO FRUSTRATING. HELP US!!!!