Export data to Excel

[rodomerida]

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

[itw_synapse]

Absolutely critical

[jim4]

'+1

[willywonka1]

I like chocolate

[drspock]

Yes please

[maxime_lesperan]

This should be the top priority in term of development. It's a show stopper for user adoption.

[maxime_lesperan]

Kim - We need to export the data as it appear in the table/matrix including formatting, subtotals, etc. Also, this is a duplicate of : https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13224069-export-excel

[gursikh133]

This is must have feature. I am really dying for this feature. There is also another big issue with PBI Desktop with excel. That we are unable to select PBI Desktop column and rows and paste in excel. This facility should be available from Edit Query mode or the Data Mode. Thanks

[neil_barrett]

Kim - I fear you haven't understood the request. Making what the service does available on the desktop client doesn't meet the need. I agree with Jeff, this should be a WYSIWYG export for the matrix/table visual. Tableau has this feature and it works really nicely to export simple tables of data without having to reformat or worse, rebuild by hand! I'd urge you to download their trial and see what we mean. It would also be nice to be able to select to copy and paste individual cells, columns or a range of data within a matrix. But right now i'd settle for a dumb WYSIWIG export of the whole table i could tidy up myself in Excel.

[chriss3]

Can we export more than 150,000 rows as well? Haven't been able to figure out a way to export more than that.

[jmeyer6]

Kim - can we get an update on this request? Neil Barrett explains it very well. See his comments. As an organization, we are contemplating switching to Tableau. Microsoft is falling behind.