Forum Discussion
Azure Map Visual
In the Azure Maps visual in Power BI, you don’t have the ability to add multiple dynamic layers from different tables directly, which is why you only see options like Bubble Layer or Filled Map in the settings. That limitation is the reason you had to combine your customer and service location data into one table and distinguish them by color. If you want to keep them separate, one workaround is to use a Reference Layer, where you prepare your service locations as a GeoJSON file and overlay them as pins on the map while still showing your customer data as bubbles. However, these reference pins will be static and won’t behave like fully interactive data points. If your requirement is to have multiple interactive layers (for example, customers as one layer and service centers as another, both dynamic), then Power BI’s Azure Maps visual cannot do this, and you would need to either continue with your combined table approach or use the ArcGIS Maps for Power BI visual, which does support multiple layers.
Hi DJ-P
Yes, you can add service locations as pins in Azure Maps in Power BI, but it requires thinking of them as a separate layer of geographic data rather than merging them into your customer table. Right now, your workaround of adding them into the same table and differentiating by color works, but it mixes two different entities (customers and service centers), which makes maintenance and analysis harder.
The better way is to keep two datasets (customers and service locations) and use them as different layers in your map. In Power BI’s Azure Maps visual, you can add multiple layers like bubbles, reference layers, or symbol layers. For your scenario:
-
Customer locations → Keep them in one dataset and display them as bubbles (with size representing customer density, spend, or just uniform bubbles).
-
Service locations → Add them as another dataset and use the Symbol Layer (pins, markers, or custom icons). This way, they show up as distinct points (like pins) overlaid on the same map.
You don’t need a relationship between the two tables unless you want to filter customers by service center. For example, if you want to calculate the nearest service center for each customer, you’d need DAX logic or a calculated column (using latitude/longitude distance formulas). But if your goal is just visual layering (customers vs. service centers), you can directly layer them on the same Azure Map visual without creating relationships.
Here’s how you could approach it:
-
Load your Customer and Service Location tables separately.
-
Add an Azure Maps visual to your report.
-
In the Layer pane of Azure Maps, add one layer for Customers (Bubble Layer) and another for Service Locations (Symbol Layer with pin icon).
-
Customize formatting (color, icon, size) so service centers are clearly visible as pins while customers remain bubbles.
I did step 1 and 2 as listed by you. however, i dont get the option for adding different layers.
In the Azure Maps visual in Power BI, you don’t have the ability to add multiple dynamic layers from different tables directly, which is why you only see options like Bubble Layer or Filled Map in the settings. That limitation is the reason you had to combine your customer and service location data into one table and distinguish them by color. If you want to keep them separate, one workaround is to use a Reference Layer, where you prepare your service locations as a GeoJSON file and overlay them as pins on the map while still showing your customer data as bubbles. However, these reference pins will be static and won’t behave like fully interactive data points. If your requirement is to have multiple interactive layers (for example, customers as one layer and service centers as another, both dynamic), then Power BI’s Azure Maps visual cannot do this, and you would need to either continue with your combined table approach or use the ArcGIS Maps for Power BI visual, which does support multiple layers.
Got it, thank you for your assistance