cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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.

1 REPLY 1
Highlighted
Super User III
Super User III

Re: Get Data - Load - Lat Lon data modified

@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 PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021