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
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.