on 16 Jun 2016 04:52:21
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
Administrator on 13 Sep 2017 04:16:31
This is supported today in the Power BI service; however, it is not yet supported in Power BI Desktop. We'll consider this for a future release.
- Comments (39)
RE: Export data to Excel
Sorry and following my comment below, all you would need to do - at a minimum - is allow the user to copy the SEE DATA view. You know, move their cursor over the SEE DATA table and press copy and then paste! But alas. HELP!!!
RE: Export data to Excel
The minimal feature in PBI online is inadequate. Structure and formatting are lost even when going directly to Excel. Qlik and other tools give a true representation of what's on the screen for all types of charts and graphs. We're trying to replace Qlik with PowerBI for all of our clients and this is the only real problem. Please fix this - it's a huge issue for accountants and others who insist on an Excel version "they control, so they trust won't change" and that they can easily annotate using Excel.
RE: Export data to Excel
Is it really already available in Power BI service? It doesn't appear to be.
RE: Export data to Excel
This feature exists in the on-line version.
Why not to have put back it in the version PowerBI desktop report server?
Thanks
RE: Export data to Excel
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 !
RE: Export data to Excel
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
RE: Export data to 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.
RE: Export data to Excel
Duplicate of https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13224069-export-excel
RE: Export data to Excel
It would be really nice to have both visuals and its data of the report exported to Excel.