set dot as decimal separator

[Anonymous]

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 decimal separation 

but when I use get data´, the decimal depeared totally 

it should be 51.28766 then in Power bi it become 5128766,00 kr  

could any on give suggestion how to solve this_

THnka you!

[v-yuta-msft]

@Anonymous,

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.

[Anonymous · Accepted solution]

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 

[tarunsingla]

On your report (not in the query editor), check under Modeling Tab, what is the Data Type and Format for this field. Looks like its set to Currency. Change it to decimal number. And additionally, you can change the Data category as well to Latitude or Longitude.