Skip to main content

Power BI

Needs Votes

Export current view to Excel, not just a csv

Vote (93) Share
Aaron's profile image

Aaron on 15 May 2016 06:11:35

Currently, we can export the data from a report, which will export to a .csv file, but the structure of the csv doesn't necessarily match the structure of the current view of data.

This is not helpful for our users that do not know how to develop a pivot chart but would still like to work with the numbers they see on the report. We'd like to have an export button, and have whatever the user is seeing (aggregates / totals, etc., not the raw data) be exported to an excel file.

Comments (6)
Aaron's profile image Profile Picture

SudharshanKopperla on 06 Jul 2020 00:11:43

RE: Export current view to Excel, not just a csv

Export all the tabs/multiple tabs to excel is one of the basic features of any reporting tool

Aaron's profile image Profile Picture

Christine Cayen on 06 Jul 2020 00:11:23

RE: Export current view to Excel, not just a csv

Can't believe that you can only export one at a time - best to export all for testing of report data!

Aaron's profile image Profile Picture

jpd on 05 Jul 2020 23:58:34

RE: Export current view to Excel, not just a csv

Im a little suprised they didnt put this in the very first release.

Aaron's profile image Profile Picture

Power BI User on 05 Jul 2020 23:38:48

RE: Export current view to Excel, not just a csv

We need to be able to export to an .xlsx file, rather than .CSV. Text fields with a numeric value are losing their leading 0's which is causing us issues.

Aaron's profile image Profile Picture

Kevin L on 05 Jul 2020 23:29:05

RE: Export current view to Excel, not just a csv

Still needed, business users do not wish to rebuild the report !

Aaron's profile image Profile Picture

Ella Haldén on 05 Jul 2020 22:19:21

RE: Export current view to Excel, not just a csv

Today it is only possible to export to CSV file which gives the report a very ineffective design when opening it in excel. I want the possibility to export the data directly to excel so that all the columns are uploaded as in Power BI desktop/website and I also want the possibility to export all my pages in the file at the same time.