Forum Discussion
Azure Map displays address incorrectly
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
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.