Forum Discussion
Export data doesnt match
I'm running across this same issue when upper management is trying to export the data.
The bar charts and tables total matches. However, the export data does not match the visuals in Power BI.
Is there a fix for this?
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.
We are having the same issue, and understand that the data will be in a different format. However, after exporting the underlying data, we have added up the numbers, and the total does not match the totals shown in the visualization. Strangely, the visualization numbers are correct, and match our underlying database. The Export function seems to be unreliable.
This is a problem for us, since we are using it for User Acceptance Testing with our more savvy users. They export the underlying data for the visualizations to verify that it is correct for signoff.
Are the Export Data problems planned to be addressed soon?
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.
