Skip to main content
Microsoft Idea

Power BI

Needs Votes

Allow export of summarized data

Vote (365) Share
Anonymous's profile image

Anonymous on 12 Jun 2018 23:44:23

Power BI leads the user to believe it is possible to export summarized data at the level of the current view. In fact, the result of [Matrix grid] > Ellipsis > Export data is that data is exported at the lowest level of the drill-down path.

In one case, I am viewing 4 rows of data in my matrix grid (drilled up to the top level of the data hierarchy). When I export to xlsx, i get over 15,000 rows of data (summarized at the lowest level of my data hierarchy).

Users should be able to export data at the level they are currently drilled down to on their report.

Comments (53)
Anonymous's profile image Profile Picture

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

RE: Allow export of summarized data

Please add this feature. I allow details in my matrix columns to drill down for further insight but at whatever level the user is viewing the data should be an option for exporting.

Anonymous's profile image Profile Picture

Power BI User on 05 Jul 2020 23:39:43

RE: Allow export of summarized data

I support allowing export of summarized data.

Anonymous's profile image Profile Picture

Power BI User on 05 Jul 2020 23:39:42

RE: Allow export of summarized data

This is a readily available feature in competing data visualization products and should not be missing from Power BI's feature set!

Anonymous's profile image Profile Picture

Power BI User on 05 Jul 2020 23:39:42

RE: Allow export of summarized data

Please allow this feature in the 'Line and Stacked Column Chart'! It would allow ease of use for exporting data out of timeplots.

Anonymous's profile image Profile Picture

Jason on 05 Jul 2020 23:39:42

RE: Allow export of summarized data

This feature is critical to be able to use these reports as we need.

Anonymous's profile image Profile Picture

Power BI User on 05 Jul 2020 23:39:39

RE: Allow export of summarized data

Need this asap for my team please

Anonymous's profile image Profile Picture

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

RE: Allow export of summarized data

Please also allow this on other hierarchy enabled visuals like time plots by date

Anonymous's profile image Profile Picture

Jess on 05 Jul 2020 23:38:14

RE: Allow export of summarized data

it is ABSURD that this does not exist yet.

Anonymous's profile image Profile Picture

Briton Wells on 05 Jul 2020 23:36:33

RE: Allow export of summarized data

This would be nice to have - especially for date hierarchies, users currently have to re-pivot the data in excel in order to roll up to the year, for example.

Anonymous's profile image Profile Picture

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

RE: Allow export of summarized data

This feature is critical to be able to use these reports as we need.