Forum Discussion

Jan_Trummel's avatar
Jan_Trummel
Helper IV
1 year ago
Solved

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, Cou...
  • v-echaithra's avatar
    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:

    https://dev.virtualearth.net/REST/v1/Locations?q=Hannah-Arendt-Platz+1,30159+Hannover,Germany&key=YOUR_BING_API_KEY

    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