Power BI

Needs Votes

Allow export of summarized data

Vote (237)

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)

Comments (39)

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:09:34

RE: Allow export of summarized data

Please implement- this would help a lot for our Org and is a critical reporting necessity! What is the status on this now in March of 2020?

0e73456a 026d-4dc3-b325-51b7f8dc634d on 06 Jul 2020 00:08:09

RE: Allow export of summarized data

We'd like this too! Sometimes, the data shown in a matrix at a higher level isn't able to be recalculated in Excel with a pivot table if it's a measure where the columns being used aren't included in the table.

2c08f769 5e47-4ad0-b27d-992e2095446e on 06 Jul 2020 00:06:27

RE: Allow export of summarized data

I agree this would be much appreciated

8db6987b aeb1-406f-b63a-12025e689da6 on 06 Jul 2020 00:05:04

RE: Allow export of summarized data

Please enable the export of summarized data. This is desperately needed to avoid further time-consuming processing after data is exported.

4674e931 7f23-4bb3-bc43-bfbff71d1faa on 06 Jul 2020 00:04:14

RE: Allow export of summarized data

Much needed feature. Please add!

c92f549d acf9-4840-8052-4dbf50d8b54a on 06 Jul 2020 00:02:40

RE: Allow export of summarized data

I reiterate all of the comments before me. My users want to export visual data at the same hierarchical level with which the visual is drilled at the time of the export.

PLEASE add this functionality, as there are and WILL ALWAYS be instances where people want raw data that they can manipulate in excel!

Thanks!

cd976431 dafd-4d00-8982-624f3f080102 on 06 Jul 2020 00:02:26

RE: Allow export of summarized data

Most definitely need this. It is great to create a matrix that can be drilled into, but users often need to export at a certain level. The underlying data is often too large to export and we would also rather not recreate in excel with Pivot tables.

cfc3b45b 1c0e-42c9-a706-71ead64f1b67 on 06 Jul 2020 00:02:08

RE: Allow export of summarized data

Highly appreciated. I now have to build separate Reports for the different drilldown Levels.

35f16301 f13d-4dc8-b9bb-d38fb582a549 on 06 Jul 2020 00:02:06

RE: Allow export of summarized data

Please add!!!

1853fe9c 7f93-4acd-9522-f9e55694a3d6 on 06 Jul 2020 00:02:06

RE: Allow export of summarized data

This is a must have feature!