Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

rodomerida

Export data to Excel

Submitted by on ‎06-15-2016 09:52 PM
It would be nice to have the option to export a table to an excel file, right now is only on CSV format but someone working on a different ecosystem and does not have Power Bi would need to rework the data and that does not make any point to have PowerBi
Status: Completed
See more ideas labeled with:
41 Comments (41 New)
Comments
batmandakh_g
New Member
‎07-05-2020 03:34 PM
It would be really nice to have both visuals and its data of the report exported to Excel.
ovchinnikov
New Member
‎07-05-2020 03:36 PM
Duplicate of https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13224069-export-excel
pbiideas1
New Member
‎07-05-2020 03:51 PM
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.
carvalhoelder
Advocate II
Advocate II
‎07-05-2020 03:52 PM
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
Joseph_Nataraja
New Member
‎07-05-2020 03:56 PM
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 !
antoine_massip
New Member
‎07-05-2020 03:57 PM
This feature exists in the on-line version. Why not to have put back it in the version PowerBI desktop report server? Thanks
pbiideas1
New Member
‎07-05-2020 03:59 PM
Is it really already available in Power BI service? It doesn't appear to be.
jxm1
New Member
‎07-05-2020 04:00 PM
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.
abeer2
New Member
‎07-05-2020 04:00 PM
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.
wherwe
New Member
‎07-05-2020 04:00 PM
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!!!!