cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Top Kudoed Authors
Users Online
Currently online: 368 members 3,632 guests
Please welcome our newest community members: