Export Data to CSV/Excel get different result

[max_song_GX]

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, as the sum of column B should be  100% (CSV result to 100.1%)

I expeted whether user select exported to CSV or Excel , the result should be same.

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

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.

[Akash_Varuna · Accepted solution]

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.