Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.