When importing latitude and longitude data into QuickSight, sometimes the scaling is wrong by a factor of 1/1000

[ErikG]

Hi @DanielH
see also

Quicksight dividing latitude and longitude values by 1000

I am trying to create a “Points on map” visual in my Quicksight dashboard. The latitude and longitude values appear correct in the dataset, however when I try to use the fields in my map I see it has divided the original value by 1000. For example, a latitude of 40.8422403 in the dataset shows up as a value of .04 (which I’ve checked by viewing the latitude/longitude values in a table visual). The fields are correctly tagged as Latitude and Longitude in the dataset. This is making it impossible …

it is also an CSV datasets.
BR