Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Export Summarized Data not Matching Power BI

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!

Need Help

1 Reply

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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!