Create fast, customizable heatmaps, point cluster maps, and graduated circle maps with the Mapbox Visual for Power BI using Microsoft Power BI Desktop and Online. The Mapbox Visual can be imported and accessed as a visualization plugin inside Power BI. This guide will walk through getting started with the Mapbox Visual and how to create a Mapbox-powered visualization in Microsoft Power BI. A Mapbox account and a Microsoft PowerBI account are required.
Before diving in, make sure you have the following ready to go:
- Mapbox account. You will need a Mapbox access token to add the Mapbox Visual in Power BI. Sign up for free at mapbox.com/sign-up.
- Power BI account. Sign into your Power BI account or create a new one.
- Mapbox Visual for Microsoft Power BI. Download the latest Mapbox Visual from the open-source GitHub repo.
- Data. This guide uses a sample CSV file with US healthcare spending derived from data.gov.
Add data to Power BI
Start by adding data to a Power BI workspace.
Add a new dataset
- Sign into your Power BI account.
- Click Get Data to import or connect to a data source.
- To import the healthcare data you downloaded earlier, choose to Import a File.
- Choose Local file and upload the CSV file.
Create a new report
In your Power BI workspace, navigate to the Datasets tab and create a new report by clicking the bar graph icon next to your new dataset. The report window will open and you will be able to edit your new report.
Add the Mapbox Visual to your Report
You’ll add the Mapbox Visual using the Visualizations pane:
- Click the three-dot ellipsis and select Import from marketplace.
- Enter “Mapbox” in the search menu and press enter.
- Click the Add button next to the Mapbox option to add it to your Power BI report. It will appear as a blue Mapbox logo on your visualizations toolbar.
Create a visualization
Click on the Mapbox icon in the Visualizations pane to add a new visualization to your report. While customizing your visualization, you’ll work in both the Fields and Format panels within the Visualizations pane:
- The Fields panel is where you will specify which data fields to associate with different types of Mapbox layers (for example map styles, heatmaps, circle maps, and cluster aggregation).
- The Format panel is where you will specify the visualization style for each layer, such as color and radius.
Initialize a visualization
In the Fields panel, drag the
longitude fields from your data onto the Latitude and Longitude shelves, and make sure that the Do not summarize option is checked for both fields. You should see the Mapbox visualization container populate with instructions on how to create your first visualization.
Connect your Mapbox account using your access token:
- Click on the link, Click here to get a free Mapbox access token, in the visualization container. Accept the external link request if prompted. You will be forwarded to either the Mapbox sign up page or your Mapbox account page.
- If you don’t have a Mapbox account, sign up with your email address.
- Copy your Mapbox Access token from your account page.
- Back in Power BI, go to the Format panel and find the Viz Settings option. Paste your access token in the Access token field.
You will see your first map visualization!
Change the map style
With the Mapbox Visual for Power BI, you can change the map style used in your visualizations. You can use any Mapbox default style or create a custom map style with Mapbox Studio. To update the map style:
- In the Format panel, select Viz Settings > Map Style.
- Select from any default map style. This example uses the Mapbox Satellite style.
Now you’ll see your data on top of a satellite map.
Create a cluster layer
Next, you’ll adjust the visualization to illustrate where the average covered costs are lowest in the US using a cluster layer.
In the Fields panel, add the
Avg Covered Charges field from your data to the Cluster shelf.
In the Format panel:
- Turn the Cluster layer On and the Circle layer Off.
- Under Cluster, select
maximumfrom the Aggregation type drop down list.
Style the cluster visualization
In the cluster Format panel:
- Change the Min Color to
FEC0BFand the Max Color to
- Change the Cluster Radius to
- Set the Blur to
- Set the Stroke Width to
- Set the Max Zoom to
Update layers based on zoom level
Sometimes you may want to visualize data differently at different zoom levels. With the Mapbox Visual for Power BI, you can use multiple layers in a single visualization and specify at which zoom levels each layer should be displayed. Here, you’ll show a cluster layer at low zoom levels (zoomed further out) and a circle layer at high zoom levels (zoomed further in).
Add data properties to shelves
In the Fields panel:
- Add the
Average covered chargesdata field to both the Color and Size shelves.
Provider Idto the Tooltip shelf.
Style the circle layer
Then, in the Format panel re-enable the circle layer by toggling the Circle layer On, and update the style properties:
- Set the circle Radius to
1and the Zoom scale factor to
- Set the circle Min Color to
FEC0BF, Med Color to
FD817E, and Max Color to
- Set the circle Stroke Color to white.
- Set the circle Min Zoom to
6. This will hide the circle layer while the cluster visualization is being displayed.
Congratulations! You created a visualization in Microsoft Power BI using the Mapbox Visual for Power BI.
Want to do more with Mapbox and Power BI? Contact sales to learn what else is possible — from adding custom shapes to visualize territories, adding detailed indoor maps, or visualizing billions of data points.