Export Summarized Data?

[connork]

I have a number of matrices summarizing data for business users; is there a way for the end-user to export the matrix data at the level summarized in the report?

Example:

- Columns are 2017 days, summarized by month

- Rows are Department (level 1) and then Emplyee (level 2)

- Values are hours by employee by day

If an end user tried to export the summary showing top level (depts on rows, months on columns), the summarized export still gives rows that show the daily totals by employee. I know it is a quick pivot to get back to the format, but not all business users can do this.

Tried searching for sometihng in suggestions, but to no avail. 

Ideas?

[lgroger]

For anyone who may have stumbled across this post, I found this idea that you can vote for this functionality to be added.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34526479-allow-export-of-summariz...

[Marilie]

The problem has not been solved correct? How do i export the report as it currenlty on Power Bi?

[v-yulgu-msft · Accepted solution]

Hi @connork,

Based on my test, by default, export summarized data will export the bottom level summarized data. It is not able to export current level data which we have seen in visual. Maybe you could submit this feature request at ideas page: https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

Yuliana Gu