Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Is there anyone that can explain why commas are changed to dots when i change from general to text datatype?
Solved! Go to 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
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
@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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |