Localización Islas Azores

This is a known limitation with some map visuals, including Azure Maps — they sometimes struggle to resolve certain regions like the Azores when using administrative fields like province or region names.

Here are a few things you can try:

1. Use Latitude and Longitude
   Since you mentioned that coordinates work, the most reliable solution is to include Latitude and Longitude columns in your data and use them in the map visual. This bypasses the name resolution issue entirely.

2. Add a Country Context
   If you're using just "Azores" or "Açores" as the province, try adding a separate column for Country and set it to "Portugal". Then use both Province and Country in the map visual — this can help Azure Maps disambiguate the location.

3. Use a Custom Location Table
   If you frequently work with regions that are hard to resolve, consider creating a custom location dimension with standardized names and coordinates. You can then join this to your fact table and always use coordinates for mapping.

4. Check for spelling/encoding issues
   Make sure there are no extra spaces or encoding mismatches (e.g., "Açores" vs "Azores") — sometimes even small differences can cause the map to fail.

Let me know if you want help building a custom location table or using coordinates dynamically.

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