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.
