Forum Discussion
Export data doesnt match
We are having the same problem, and understand that the underlying data will be in a different format than the visualization. That is not the issue.
We have exported the underlying data to a visualization, and added up the numbers in the extract. The totals obtained from the extract do not match those shown in the visualization. The viz is correct and matches our database totals, but the exported data is not. It seems to be a problem in the export function itself.
This is a problem for us, in that our users are exporting data from visualizations as part of User Acceptance Test. They want to verify that the totals and calculations shown match the underlying data.
Until the Export Data feature can be investigated, it seems that it is unreliable, and should not be used for testing values.
Please provide a screenshot of the visual, a screenshot of the export data, and the DAX used for any measures. You can provide dummy data but make sure it approximates the actuals in terms of the differences between visual vs export.
I've been working with Power BI daily and use it for reporting and leadership team reviews (high visibility numbers) and have never had a problem with data export.