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 wanted to check if you had the opportunity to review the information provided by Akash_Varuna . Please feel free to contact us if you have any further questions. If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.