Export data from a report

You have many more options when exporting data from a report visual in the Power BI service. To illustrate the different options, create a stacked column chart that includes:

• Data With Current Layout
• Summarized data
• Underlying data

Export summarized data

Select the option for summarized data if you want to export data based on what you see in that visual. This type of export shows you only the data (columns and measures) that is being used to create the visual. Since this visual has a hierarchy, your export contains aggregated data for the full hierarchy.

Select this option if you want to see the data in the visual and other data from the semantic model (see chart later in this article for details). If your visualization has an aggregate, selecting Underlying data removes the aggregate.