Skip to main content

Power BI

Needs Votes

Allow export of summarized data

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

784c5b67 311f-47b0-8107-356e553a1f17 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

5d69e45c 9038-485a-8944-1e18c5c8de19 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

dfc524ce fb91-445b-a29b-6bc14f6dc476 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

3fd374eb 6311-4557-b6eb-d94bf1c6c1b0 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

4c5d90e4 f7eb-4168-8531-22a360d900cc 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

e25984dc b716-4828-9fbd-d2d97656fb39 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.

Anonymous's profile image Profile Picture

1ce9f1d0 1d42-47c8-892e-97e9b803fb22 on 05 Jul 2020 23:34:47

RE: Allow export of summarized data

This feature has to be added ASAP. Users need it on high priority so that they can export at any level they are viewing.

Anonymous's profile image Profile Picture

f90f643a 7b57-4ed8-9a21-80293f4c5a95 on 05 Jul 2020 23:34:47

RE: Allow export of summarized data

This is a feature that is highly desired by users so that they can export at any level and also export what they see on the report. Please add this feature as soon as possible

Anonymous's profile image Profile Picture

d8011d72 7076-4cec-9be4-65e75fbe5557 on 05 Jul 2020 23:34:03

RE: Allow export of summarized data

I 100% need this functionality! For now, I have to create a duplicate page with the visual's lower levels removed. Definitely not ideal.