EXPORTED DATA NOT MATCHING VISUAL

[shuaibu_kida]

Hi

I exported data from visual to excel cvs format, but there is difference in the TOTALS in visual and excel. Total in visual 5,1520,662.01000003 and Total in excel 50,839,853.37

Cant figure out the problem, needed to submit a report ugently, can anyone help please.

Thank you

[Anonymous · Accepted solution]

Hi  @shuaibu_kida ,

Do you add any filter over this table visual?

If you have applied filters to the visualization, the exported data will export as filtered.

The data that gets exported is the UNDERLYING data used in the visual, not necessarily in the exact format that the visual is showing it.  For example, if you have a matrix with a hierarchy on the rows and columns and you expand all to the bottom level, when you export you won't get a table with the same structure.

If there is a summary, it will also cause the total number of Export data to not match. You can use Power Query to add an index to each column to prevent the same columns from being aggregated together.

This is the relevant limitation of Export data

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-de...

This is the related document, you can view this content:

https://community.powerbi.com/t5/Desktop/power-bi-export-to-excel/m-p/947520

https://community.powerbi.com/t5/Desktop/Wrong-totals-different-than-export/m-p/201233

https://community.powerbi.com/t5/Report-Server/Export-of-Table-to-Excel-yields-different-sum-in-Exce...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.