Power BI

How to Create Interactive Maps in Power BI Using Azure Maps

How to Create Interactive Maps in Power BI Using Azure Maps

Table of Contents

Introduction

With the use of interactive maps in Microsoft Power BI, it has now become possible to extract information from location-based data. As highlighted in Exploring the Latest Mapping Features in Power BI, the new features in Power BI have made it easy for people to visualize and analyse geographical data. One of the best ways in which geographical data can be analysed is by Azure Maps visual. 

This blog post will discuss how to develop interactive maps using Azure Maps in Power BI.

What is an Azure Map in Power BI?

Power BI allows data to be visualized on interactive maps through Azure Maps. Different from ordinary map visuals, Azure Maps includes additional features such as multiple layers, heatmaps, and up-to-date traffic data. It also includes better geocoding and supports companies that require geographic analysis, such as those in logistics or expanding their business operations.

Why Use Azure Maps?

Here are some key features of Azure Maps:

  • More advanced visualization techniques (bubble, heat, and filled maps).
  • The ability to layer different types of data.
  • Better performance when dealing with large volumes of data.
  • Smooth integration with other Azure services.

Step-by-Step Guide to Creating Interactive Maps

Prepare Your Data

It is necessary to start with the preparation of data containing geographical variables:

  • Countries.
  • States/Provinces.
  • Cities.
  • Latitude and longitude.

Next, make sure that all information you have is properly arranged within Power BI according to the corresponding data categories. For instance, set columns like “City” or “Country” with the appropriate data category under the modeling tab. 

For information about Bubble Maps, refer to this blog: Power BI Bubble Map Tutorial with Azure Maps – Australia

Add Azure Maps Visual

You can use the Power BI sample datasets from the link here, or download the files directly from the link provided at the end.

In Power BI Desktop:

  1. Create a new page, and then add the visual.
  2. Click on the Visualizations pane.
  3. Choose the Azure Maps icon.
Maps in Power BI
Figure 1: Power BI Visualization Pane showing the Azure Maps icon

After this step, you should see a blank map created within your report. Once added, a blank map canvas will appear in your report.

Assign Data Fields

Drag and drop fields into the Azure Maps visual:

  1. Location: PostalCode.
  2. Legend: Store Type.
  3. Size: This Year Sales.
  4. Tooltips: First City.

This step transforms raw data into plotted points on the map.

Azure Map Visual
Figure 2: Azure maps Power BI with fields pane displaying location, latitude, longitude, legend, and size selected.fields. selected.

Customize Map Layers

Azure Maps allows multiple layers, making your map more interactive and insightful:

  1. Bubble Layer: Displays data points as circles.
  2. Heat Map Layer: Shows the density of data.
  3. Filled Map Layer: Colores regions based on values.

You can toggle between layers or combine them to create a richer visualization.

Enable Interactivity

Interactivity is where Azure Maps shines:

  1. Zoom and pan for detailed exploration.
  2. Clickable data points for drill-down analysis.
  3. Cross-filtering with other visuals in your report. For instance, when you click a region on the map, it filters data in other visuals in your report.

Format Your Map

Use the formatting pane to refine your visual:

  1. Customize colours and themes.
  2. Switch between different map types (road map, satellite view, grayscale).
Maps in Power BI
Figure 3: Changing map styles between road, satellite, and grayscale views.

3. Customize labels and legends.

Map
Figure 4: Customize labels in the Azure Maps formatting pane.

4. Enable map controls like zoom buttons.

These options help align the map with your report’s design and storytelling goals.

What Information You Share with Azure?

When you use Azure Maps visual in Microsoft Power BI, it relies on cloud services from Azure Maps to display maps accurately. Power BI exchanges information with Azure to a certain extent for map rendering and functionality. 

  • Map Display Requests: Power BI transmits your current map view including the location, the zoom level, and the map boundaries to Azure and receives the relevant map tiles.
  • Geographic Data Processing: Power BI transmits the geographic data that you enter into the Location field to Azure for geocoding.
  • Usage & Diagnostic Data:  If telemetry is turned on in Power BI, then Power BI collects the data about the usage of the visual by you.

Such interaction is vital for ensuring an interactive map. However, it would be best if businesses evaluated their data policies and made sure, they align with cloud usage standards.

For a more detailed walkthrough and some additional configuration settings, please refer to the Microsoft Azure guide on how to set up Azure Maps within Microsoft Power BI: Power BI visual: Azure Maps. 

For further details on privacy and usage terms concerning the Azure Maps, visit the Microsoft Azure Legal Information.

Final Thoughts

Developing interactive maps in Power BI using Azure Maps transforms the way data is visualized and analyzed. It offers the ability to analyze data from a geographic perspective, uncovering valuable insights and connections that traditional diagrams may fail to reveal. Thus, Azure Maps become an indispensable addition to Power BI.

By following the steps outlined above, you can start building visually compelling and highly interactive maps that bring your data to life.

FAQs

Azure Maps is an advanced mapping visual in Microsoft Power BI that allows users to create interactive and layered geospatial visualizations for better data insights.

While ordinary map visuals are limited to basic capabilities, Azure Maps offers multilayered visuals, heatmaps, route visualization, and customizable options.

Geographic data is required to create maps in Power BI. You need country names, city names, or latitude and longitude.

Extended Learning & References  

Leave a Reply

Your email address will not be published. Required fields are marked *