Difference in export data and value shown on visualisation

[Anonymous]

Hi PowerBI community,

I am having an issue that the visualisation on Power BI is different from the data that I exported. I have searched for this problem but to no avail. Does anyone knows the reason why and how do I rectify this issue? 

[Anthony_A]

I am understanding the export function, but my visualization is less than what is exported. Why is that the case? 

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

Do you export the data from Service or desktop？

If you export from desktop,you could only export summarized data,that's why you see the differences.

Make an example as below:

If you export below visual to csv file:

You would see:

But actually the data is as below:

All depends on whether you have exported the underlying data.

Check the reference below:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

Best Regards,
Kelly

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