cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nirvana_moksh Established Member
Established Member

Summarized Data vs Underlying Data

Hello All,

 

What are the actual export differences of each if anyone can list them?

 

Thank You

1 ACCEPTED SOLUTION

Accepted Solutions
acbg Member
Member

Re: Summarized Data vs Underlying Data

@nirvana_moksh

Summarized data only exports aggregated data points that you see in the visual while Underlying data exports additional data that are not displayed but are relevant for the visual.

 

Here is the link where MS explains the difference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

 

Based on below chart.

 

Summarized data: select this option if you want to export data for what you see in that visual. This type of export shows you only the data (columns and measures) that you chose to create the visual. If the visual has an aggregate, you'll export aggregated data. For example, if you have a bar chart showing 4 bars, you will get 4 rows of data. Summarized data is available as .xlsx and .csv.

In this example, our Excel export shows one total for each city. Since we filtered out Atlanta, it is not included in the results. The first row of our spreadsheet shows the filters that were used when extracting the data from Power BI.

 

Underlying data: select this option if you want to see the data in the visual and additional data from the model (see chart below for details). If your visualization has an aggregate, selecting Underlying data removes the aggregate. When you select Export, the data is exported to an .xlsx file and your browser prompts you to save the file. Once saved, open the file in Excel.

In this example, our Excel export shows one row for every single City row in our dataset, and the discount percent for that single entry. In other words, the data is flattened and not aggregated. The first row of our spreadsheet shows the filters that were used when extracting the data from Power BI.

View solution in original post

2 REPLIES 2
acbg Member
Member

Re: Summarized Data vs Underlying Data

@nirvana_moksh

Summarized data only exports aggregated data points that you see in the visual while Underlying data exports additional data that are not displayed but are relevant for the visual.

 

Here is the link where MS explains the difference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

 

Based on below chart.

 

Summarized data: select this option if you want to export data for what you see in that visual. This type of export shows you only the data (columns and measures) that you chose to create the visual. If the visual has an aggregate, you'll export aggregated data. For example, if you have a bar chart showing 4 bars, you will get 4 rows of data. Summarized data is available as .xlsx and .csv.

In this example, our Excel export shows one total for each city. Since we filtered out Atlanta, it is not included in the results. The first row of our spreadsheet shows the filters that were used when extracting the data from Power BI.

 

Underlying data: select this option if you want to see the data in the visual and additional data from the model (see chart below for details). If your visualization has an aggregate, selecting Underlying data removes the aggregate. When you select Export, the data is exported to an .xlsx file and your browser prompts you to save the file. Once saved, open the file in Excel.

In this example, our Excel export shows one row for every single City row in our dataset, and the discount percent for that single entry. In other words, the data is flattened and not aggregated. The first row of our spreadsheet shows the filters that were used when extracting the data from Power BI.

View solution in original post

Babatayomi Visitor
Visitor

Re: Summarized Data vs Underlying Data

Hi guys i observed that when i export underlying data from my matrix visual, it shows as summarized data and vice versa. Has anyone encountered this issue? How did you resolve it?

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 266 members 2,865 guests
Please welcome our newest community members: