Power BI

Needs Votes

Allow export of summarized data

Vote (365)

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

Comments (53)

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.