Power BI

Needs Votes

Allow export of summarized data

Vote (367)

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 (51)

Comments (51)

Pritish Ekka on 28 Apr 2022 20:25:53

RE: Allow export of summarized data

When is this coming? We might shift to other reporting platform if this doesn't get solved in next couple of weeks.

Marta Dopierala on 03 Mar 2022 10:27:10

RE: Allow export of summarized data

This really needs to be resolved.This is a must have. Please work on it.

VIOREL RUSU on 12 Aug 2021 10:42:34

RE: Allow export of summarized data

I thought this functionality was added in the last year. What a disappointment :(

Warwick Congrave on 16 Jul 2021 10:37:36

RE: Allow export of summarized data

One of the most commonly requested features from my end users. Workaround is basically never adding drill downs, disabling one of the amazing features.

Andrew Cason on 04 Jun 2021 12:52:12

RE: Allow export of summarized data

Need an update on this functionality from Microsoft. This is going to be a deal breaker for my organization.

Przemysław Leszczuk on 27 May 2021 12:25:50

RE: Allow export of summarized data

Please add this future its confusing when you see other data in power BI than in xls file,

Reijaldy Lamdha-Fandji on 20 Apr 2021 05:02:25

RE: Allow export of summarized data

This usually creates confusion for the end users, please add this feature so the dashboards in PBI will be more user friendly in terms of extracting the data.

Ronald McVicar on 06 Apr 2021 16:29:49

RE: Allow export of summarized data

Is there a work around that anyone has found?

Ronald McVicar on 06 Apr 2021 16:26:16

RE: Allow export of summarized data

This really needs to be resolved: if summarized in a matrix then "export as summarized" should be the current visualization displayed. So if summarized (not drilled down) then Excel gives as displayed in Power BI view. Else if drilled down and or filtered you get what is visualized in Power BI View in Excel.

This is a must have. Please

Isabelle Liotta on 06 Apr 2021 15:58:32

RE: Allow export of summarized data

It's definitely a must have !