Forum Discussion
set dot as decimal separator
I have a ssv file having swedish street name and longtitude and latitde Now even able to lode correctly in to power bi I double check if i use subline I can see the long, lat having dot as deci...
Hi, I finally find a way to solve it.
1. change the excel load preference
2. change the local file 'regional setting ' only this work, not swedish or english
v-yuta-msft
Community Support
Community SupportAnonymous,
How do you connect to the ssv file in power bi desktop, have you used custom connector or others? In addtion, for troubleshooting, could you please share a sample ssv file for further test?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, I finally find a way to solve it.
1. change the excel load preference
2. change the local file 'regional setting ' only this work, not swedish or english