320
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.
STATUS DETAILS
Needs Votes

Comments

A

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

A

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

A

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

A

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

A

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.

A

Is there a work around that anyone has found?

A

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

A

It's definitely a must have !

A

This is a top request from users. They want to export the data that matches exactly at the level they see in the chart at the drill-up level. For example, if the chart displays at monthly level, users expect to download/export data at the monthly level, not at daily. Currently it is frustrating, because even if the chart can be viewed at daily, monthly, quarterly, and annual level, when users export data they always get daily level. Way too much detail and not matching what they see, so they need to then summarize again in Excel. This does not make intuitive sense.

A

adding this will be an added convenient