Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Jan_Trummel
Helper IV
Helper IV

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

1 ACCEPTED SOLUTION
v-echaithra
Community Support
Community Support

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=YO...

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

View solution in original post

6 REPLIES 6
v-echaithra
Community Support
Community Support

Hi @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.

v-echaithra
Community Support
Community Support

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=YO...

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

burakkaragoz
Community Champion
Community Champion

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:

  1. 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")
  2. Then use the Latitude and Longitude if you have them. This is the most reliable way to ensure accurate placement on the map.

  3. 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!

Cookistador
Super User
Super User

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.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.