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)
RE: Export data to Excel
Why not turn it around and allow Excel to read/Import from a PowerBI Desktop file (.pbix)?
RE: Export data to Excel
Absolutely critical
RE: Export data to Excel
Please not only for power BI desktop, but also for Power BI embedded!
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
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.
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.
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.
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.
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.
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!!!!