Skip to main content

Power BI

Under Review

Export data to Excel

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

c4bb72d8 f40a-4cba-b99b-c4bf08898eb0 on 05 Jul 2020 23:41:32

RE: Export data to Excel

Very waiting for this...

's profile image Profile Picture

2b3eb8f4 dd9f-4d11-9b56-73c6588a7e99 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

e6462cec b656-4a27-bba8-2af3ecabfbff 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

132847be 51e9-495f-9085-b11cccf868c0 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

d56cbdc2 4e8b-4f22-a50f-93404fce1534 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

24ea398e d7f5-4cdb-9382-95940ed6c703 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

bbe6891c 6c21-4e85-a0f1-85aabd5c3a37 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

b63102fc edd4-41e8-beae-94bad2936baa 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

41af951e a868-4730-940d-51ddf31f8290 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

41af951e a868-4730-940d-51ddf31f8290 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