Skip to main content

Power BI

Completed

Export data to Excel

Vote (497) Share
's profile image

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 18 Apr 2022 20:34:56

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)
's profile image Profile Picture

Power BI User on 05 Jul 2020 23:41:32

RE: Export data to Excel

Very waiting for this...

's profile image Profile Picture

Daniel on 05 Jul 2020 23:33:26

RE: Export data to Excel

Hey Kim, could you please ask your mates to implement "export to XLSX file" method in REST API for a specific visual like "Table"? This is the only feature missing, we can't move our BI environment to MS platform because of that. I have a number of scheduled reports that are automatically extracted to XLSX or CSV file and then send to clients as an attached file. Please implement that feature if you want to earn more money Microsoft!!!

's profile image Profile Picture

John Nevin on 05 Jul 2020 23:29:40

RE: Export data to Excel

Echoing others here...dealbreaker if we don't get full featured EXCEL export (including matrix subtotals and totals). This is a real problem for us.

's profile image Profile Picture

Peter on 05 Jul 2020 23:29:09

RE: Export data to Excel

How is the status for WYSIWYG export into EXCEL??

's profile image Profile Picture

Andrew on 05 Jul 2020 23:15:59

RE: Export data to Excel

Our BI users desperately need WYSIWYG export into EXCEL. This is preventing our go-live with MS Power BI, and the conversion from OBIEE.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:15:58

RE: Export data to Excel

Must required feature in PBI desktop, it was a showstopper for us to move on.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:15:53

RE: Export data to Excel

our user community desperately needs WYSIWYG export into EXCEL. We are facing pushback to go-live on our conversion from OBIEE

's profile image Profile Picture

Alex Rajkov on 05 Jul 2020 23:10:52

RE: Export data to Excel

Additionally, Csv export cannot be trusted in Germany. We have different separators. Point instead of comma and vice versa. Looks like this is confusing PBI Desktop Export.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:07:53

RE: Export data to Excel

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.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:07:53

RE: Export data to Excel

Kim - This link has an additional 499 votes and is a duplicate of this request. - https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15164733-allow-table-and-matrix-data-exports-to-match-power