Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
connork
Helper I
Helper I

Export Summarized Data?

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?

1 ACCEPTED SOLUTION
v-yulgu-msft
Employee
Employee

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
lgroger
Advocate I
Advocate I

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
New Member

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

v-yulgu-msft
Employee
Employee

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors