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

JL 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

Alex Abell 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.