Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

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 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!

tarunsingla
Solution Sage
7 years ago
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.
v-yuta-msft
Community Support
7 years ago
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
  Not applicable
  7 years ago
  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