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

7dfb9ec6 03d8-46e2-a1b9-324ded615ad3 on 05 Jul 2020 23:02:22

RE: Export data to Excel

Why not turn it around and allow Excel to read/Import from a PowerBI Desktop file (.pbix)?

's profile image Profile Picture

4b85bdab 96ed-4c10-aea7-59bb21f95bcb on 05 Jul 2020 23:02:02

RE: Export data to Excel

Absolutely critical

's profile image Profile Picture

b06af199 d781-41c5-9dd4-9e024354d132 on 05 Jul 2020 23:01:54

RE: Export data to Excel

Please not only for power BI desktop, but also for Power BI embedded!

's profile image Profile Picture

b06e72f9 cde1-4340-9122-a143f0fb497a on 05 Jul 2020 23:01:47

RE: Export data to Excel

The issue isn't saving the export as as .xlsx file instead of .csv. The issue is exporting a table/matrix as it looks in Power BI. The export option in the Power BI service labeled "summarized data" doesn't do this.

For example, the table/matrix:
Month Total Amt
Jan $100
Feb $200

Exports each record... such as:

Month Amt
Jan $50
Jan $25
Jan $25
Feb $50
Feb $100
Feb $10
Feb $40

's profile image Profile Picture

6f0e629f b5f0-4ac4-8a12-c6ddbba33d05 on 05 Jul 2020 23:01:34

RE: Export data to Excel

In today's climate, requiring voluminous data, it's totally unrealistic to have the Power BI Desktop limited to a paltry export size. Users should be able to export directly to an Excel spreadsheet, both in size and in format.

's profile image Profile Picture

8b4c3895 2b3c-4dea-8eff-3bbfab513af0 on 05 Jul 2020 23:01:26

RE: Export data to Excel

Kim, I agree that the "basic framework" is there in the service to export to excel - however when your matrix exports in a long line of single values rather than the matrix that is visible to the users in the service - they don't recognize the data nor is it usable.

I'm about to go backwards to create a pivot table off my cube just so that the users can have a table of data that they can print.

's profile image Profile Picture

177fb9da 2ddf-4932-9821-eae508410bf6 on 05 Jul 2020 23:01:09

RE: Export data to Excel

Very much agree with the sentiment that this is not currently supported in the service. My users desperately want to be able to format a matrix in the web, then export what they see on the screen into an excel file. There is no way to do this in the service or the desktop.

's profile image Profile Picture

89835596 927c-4c17-bb56-84b9a52ba1a3 on 05 Jul 2020 23:00:54

RE: Export data to Excel

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.

's profile image Profile Picture

34fe7673 5c7a-49ea-ac2c-910a93fae378 on 05 Jul 2020 23:00:30

RE: Export data to Excel

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.

's profile image Profile Picture

28401fee a134-4e13-a6da-c336ecc8e63f on 05 Jul 2020 23:00:13

RE: Export data to Excel

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!!!!