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
Thank you for reaching out microsoft fabric community forum.
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.