Export Summarized Data not Matching Power BI

[Anonymous]

Hello,

I am exporting the summarized data from a table, and the total values are drastically different from those in Power BI. Exporting the data from other tables gives the same total value, but from one specific table, the total value is different. 

Any help would be appreciated on this issue!

[v-kelly-msft]

Hi @Anonymous ,

When you select the option for Summarized data,this type of export shows you only the data (columns and measures) that are being used to create the visual. If the visual has an aggregate, you'll export aggregated data. For example, if you have a bar chart showing four bars, you'll get four rows of Excel data.

So pls check the whether there is any aggregation in that specific table.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!