Forum Discussion
Azure Map displays address incorrectly
Hello to the forum,
I have a problem with an address. The Azure Map visual displays the address incorrectly.
The address is formated in German way: "Street House Number, Postal Code City, Country".
Example: Hannah-Arendt-Platz 1, 30159 Hannover, Deutschland
The field is also definied as "address".
What can I do? Do you have any ideas?
Greetings
Hi Jan_Trummel ,
Thank you for the update.This is the most reliable workaround you can try:
Use Power Query to call a geocoding API that returns lat/lon from the address. If Azure Maps isn’t recognizing the address properly, you can try using Bing Maps API to convert the address into latitude and longitude. Once you have the coordinates, Azure Maps should display the location correctly.
You can use Bing Maps API or Google Maps or OpenCage.
Example:Parse the latitude and longitude from the response and add those coordinates to your dataset.
Use latitude/longitude columns in the Azure Map visual, this ensures exact pin placement regardless of address formatting.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"
Kind Regards,
Chaithra
6 Replies
If it is possible, I would use Power query (or the tools you used for the Transforamtion) to extract each field in separated fields
Instead of havig one field Address, you would have StrNumber, StreetName, ZipCode,City and country (you also improve the cardinality)
The last time I was facing this issue, it was because in some case, I have semi colon as separators for some fields instead of colons
Hello Cookistador ,
same as my other answer: the seperate fields weren't helpful, the address is still displayed incorrectly.
Hi Jan_Trummel ,
Azure Maps sometimes struggles with non-standard address formats, especially when the structure doesn’t match the expected "Street, City, Zip, Country" pattern.
Here are a few things you can try:
Split the address into separate fields: Instead of using one full address string, break it into:
- Street (e.g. "Hannah-Arendt-Platz 3")
- Postal Code (e.g. "30159")
- City (e.g. "Hannover")
- Country (e.g. "Germany")
Then use the Latitude and Longitude if you have them. This is the most reliable way to ensure accurate placement on the map.
If you must use a full address string, try reformatting it to:
Hannah-Arendt-Platz 3, Hannover, 30159, Germany
This format tends to work better with Azure Maps.
Let me know if you want help generating coordinates from addresses or adjusting your data model.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AIHello burakkaragoz ,
thank you for your answer. Unfortunately, it didn't helped me.
Putting the seperate fields in the visual didn't helped.
Also the reformatted address string wasn't successful.
I don't have longitude and lattitue.
Anyway, thank you!
Hi Jan_Trummel ,
Thank you for the update.This is the most reliable workaround you can try:
Use Power Query to call a geocoding API that returns lat/lon from the address. If Azure Maps isn’t recognizing the address properly, you can try using Bing Maps API to convert the address into latitude and longitude. Once you have the coordinates, Azure Maps should display the location correctly.
You can use Bing Maps API or Google Maps or OpenCage.
Example:Parse the latitude and longitude from the response and add those coordinates to your dataset.
Use latitude/longitude columns in the Azure Map visual, this ensures exact pin placement regardless of address formatting.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"
Kind Regards,
ChaithraHi Jan_Trummel ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Chaithra.
