Forum Discussion
Issue with Azure Map visual
- Add a Country column (e.g., "USA") and set its data category to Country or Region.
- Create a single Location column like "City, State PostalCode, Country" and set it as Place or Address.
- Avoid using Postal Code alone—it can confuse Azure Maps.
- Double-check data categories in Model view: City, State, Postal Code, Country.
Location = [City] & ", " & [State] & " " & [PostalCode] & ", USA"
I want to follow up on this because I am having a similar/same experience.
my data has separate columns (Property Address, City, State, Zip) which I then concant into a single Property Address column within my Power Query so I can use it conveniently to render my Power BI Reports.
Everything worked just fine within Bing Maps.
When migrating to Azure Maps my data suddenly is going around the world. So I appended ",USA" to the end which cleaned up some of the data...but am still getting terrible (inaccurate) results. Some of those properties only have City, State, Zip populated and as can be seen in my image showing the "Salem, OR, 97305, USA" is being displayed in Algeria.