Forum Discussion
Solved
Export Data to CSV/Excel get different result
Hi, I export the data from visual using these two methods, but get different results: Left is exported to CSV, right is exported to Excel: Exported to Excel is the right result, ...
Hi max_song_GX The issue might CSV exports raw data from the model, while Excel exports formatted, aggregated data, causing discrepancies like incorrect column sums.
You could try pre-aggregating or rounding values in the Power BI data model or applying consistent formatting within the visual to ensure the data exported to both CSV and Excel matches accurately.
Hi max_song_GX The issue might CSV exports raw data from the model, while Excel exports formatted, aggregated data, causing discrepancies like incorrect column sums.
You could try pre-aggregating or rounding values in the Power BI data model or applying consistent formatting within the visual to ensure the data exported to both CSV and Excel matches accurately.