Forum Discussion
Azure Map displays address incorrectly
- 1 year ago
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
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 AI
Hello 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!