Skip to main content

Power BI

Needs Votes

Allow export of summarized data

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

Dobregon on 06 Jul 2020 00:11:29

RE: Allow export of summarized data

Please add this feature, is very important for reporting purposses due to the people than check the report wants to download the data at the level of the matrix visuals that they want, not to the minimum level

Anonymous's profile image Profile Picture

Power BI User on 06 Jul 2020 00:10:55

RE: Allow export of summarized data

Please add this feature.

Anonymous's profile image Profile Picture

Power BI Ideas Admin 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?

Anonymous's profile image Profile Picture

Lori 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.

Anonymous's profile image Profile Picture

Henrik Hougaard on 06 Jul 2020 00:06:27

RE: Allow export of summarized data

I agree this would be much appreciated

Anonymous's profile image Profile Picture

Power BI User 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.

Anonymous's profile image Profile Picture

Power BI User on 06 Jul 2020 00:04:14

RE: Allow export of summarized data

Much needed feature. Please add!

Anonymous's profile image Profile Picture

Daniel Miradakis 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!

Anonymous's profile image Profile Picture

Jeffery Morris 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.

Anonymous's profile image Profile Picture

Power BI User 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.