downloading csv file problem with numbers format

[Anonymous]

Hi,

I have a problem with downloading the CSV file from a visual. The numbers get very messed up, it seems like the CSV cannot recognize when there is a comma, a .000 separator, etc.

Example: 7.567.456,34 becomes 756745634 , ot 3.111.855,22 becomes 31148552200000000.

It is strange also because there is no logic behind how numbers are changed it seems - the 2 examples are real cases from the same table.

How to fix this ? Can I do something on PBI, or have to work on Excel query editor ?

Thanks!

[Daviejoe]

Hi @Anonymous 

I'm pretty certain that, since it's exporting to a csv, it strips the data of any formatting.

The numbers should still be the same, is this not the case?

DJ

[Anonymous]

That is the thing, it seems like it is not, for example it addes a lot of random zeros...

[amitchandak]

@Anonymous , A number needs to be converted to text, if it is common separated.

Like "7,000" as 7,000 are two columns in csv. But . should remain, unless it is the whole number.

CSV is not for formatted data. It is for Data.

[Anonymous]

Yes, that is clear. I partially solved this removing decimals from PBI, now it works. Still I don't get why the CSV would add 6 zeros to the number