This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
Hi Team, I recently switched from bing map to azure map and i have postal code city name and state column, all the values are correct (for example I have data for a city in US then i checked on google and the postal code city and state is correct), still when i put these in azure map, the bubble is going into UAE region.
I categorised the column as city, postal code and state using the data view, how to resolve this
Solved! Go to Solution.
- 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.
Hi @anmolmalviya05 ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.If not,please share the requested details.
Thank you.
Hi @anmolmalviya05 ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you @danextian @Shahid12523 for the prompt response.
I wanted to check if you had the opportunity to review the information provided and resolve the issue..?If not, can you please share the requested details, so that it will be helpful for us to solve the issue
Thank you.
Are those locations correctly plotted in Bing Maps? At work, we don't rely on locaiton names but on geo coordinates.
- 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"
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 31 | |
| 24 | |
| 23 | |
| 20 | |
| 16 |
| User | Count |
|---|---|
| 63 | |
| 38 | |
| 28 | |
| 23 | |
| 22 |