Commas to dots

[tex628]

Is there anyone that can explain why commas are changed to dots when i change from general to text datatype? 

[v-yulgu-msft · Accepted solution]

Hi @tex628 ,

In your locale, for a general value, comma works as thousand delimiter. When you changed data type to text, it used dot as text delimiter.

Regards,

Yuliana Gu

[tex628]

@v-yulgu-msftThank you for the help! I did not know that you had to assign locale in dataflows aswell. It appears that it defaulted to US locale which was the issue. 

/ Johannes