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

efb36ec0 47d2-ea11-a812-000d3a579c39 on 30 Jul 2020 09:40:39

RE: Allow export of summarized data

Hi,

We need this definitely - users are confused - 90% wants to export aggregated result while other 10% needs the detailed data. This could be added as the matrix visual property with the extra switch in the "more options" menu. I would be also happy if possible to bound this feature with the bookmark so I could let users to change the export option with the button.

Anonymous's profile image Profile Picture

12732bc6 8137-4588-b80d-05fdafaaa333 on 06 Jul 2020 00:16:12

RE: Allow export of summarized data

How is this not a thing in 2020? What is the point of all the nice visuals if you cant pull the aggregated data? If i am looking at a visual that aggregated daily data by month (very cool) why does it only export daily data? This creates work that Power BI has already done for me. This defeats the purpose of Power BI, in my opinion.

Anonymous's profile image Profile Picture

2eca968c fc4e-49da-9570-b6a7e51cf3b5 on 06 Jul 2020 00:15:54

RE: Allow export of summarized data

This is so obviously neccessar, please Add !!!

Anonymous's profile image Profile Picture

d666aeda 943b-4012-9dc6-d45d8953e623 on 06 Jul 2020 00:15:46

RE: Allow export of summarized data

This is so obviously neccessary, the way the data is exported is sometimes unreadable to the end user.

Anonymous's profile image Profile Picture

a09838a8 b5de-4c24-9b5e-66a4b3b53cd4 on 06 Jul 2020 00:14:39

RE: Allow export of summarized data

Need this

Anonymous's profile image Profile Picture

a051ddfe e4fe-45dc-8040-239910b7bb64 on 06 Jul 2020 00:12:26

RE: Allow export of summarized data

it make sense to export the data of what you see on the screen.

Anonymous's profile image Profile Picture

4318cdb8 1aba-41ca-ad92-98ee0922cbfc on 06 Jul 2020 00:11:41

RE: Allow export of summarized data

tres tres utile. Merci Power BI de rajouter cette fonctionnalité!

Anonymous's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:11:37

RE: Allow export of summarized data

Please Add !!!

Anonymous's profile image Profile Picture

1c1a1b59 6a4b-4656-a6c2-34f120761f14 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

4672d12b f685-4763-8b81-044906f237fa on 06 Jul 2020 00:10:55

RE: Allow export of summarized data

Please add this feature.