Showing results for 
Search instead for 
Did you mean: 
New Member

Get Data - Load - Lat Lon data modified

I've tried loading an Excel spreadsheet and connecting to an Access database of 15,000 records of location (lat / lon) information. When I select the data to Edit in the Navigator Dialog, the data looks good. When i Load the data, all of the lan/lon data is changed to incorrect values.  Default Summarization is Sum, which I don't want. Resetting that property to Do Not Summarize does not restore the lat/lon data to correct values. How do I change the load to preserve my correct data? Very frustrating for something that should be automatic and was in Tableau.


@MBroeker It could be a result of Power BI trying to auto-detect the data type. You can disable this by going to File -> Options and Settings -> Options -> Data Load -> Type Detection, disable it

What is the data type that is set?

Another thing to check, under "Modeling" in the header:

You can set the Data Category to Latitude and Longitude for each column.

I just tested a quick sample and there are a couple things here. I have no issues with the Data Type being Decimal and the format = general and I didn't need to set the data category, but it may resolve your issue depending on the data type.


My auto detection is on btw.

Looking for more Power BI tips, tricks & tools? Check out the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors