ArcGIS maps in Power BI service and Power BI Desktop by Esri
This tutorial is written from the point of view of a person creating an ArcGIS map. Once a creator shares an ArcGIS map with a colleague, that colleague can view and interact with the map but not save changes. To learn more about viewing an ArcGIS map, see Interacting with ArcGIS maps.
The combination of ArcGIS maps and Power BI takes mapping beyond the presentation of points on a map to a whole new level. Choose from base maps, location types, themes, symbol styles, and reference layers to create gorgeous informative map visualizations. The combination of authoritative data layers on a map with spatial analysis conveys a deeper understanding of the data in your visualization.
While you cannot create an ArcGIS maps on a mobile device, you can view and interact with it. See Interacting with ArcGIS maps.
GIS stands for Geographic Information Science.
The example below uses a dark gray canvas to show regional sales as a heatmap against a demographic layer of 2016 median disposable income. As you'll see as you read on, using ArcGIS maps offers almost limitless enhanced mapping capability, demographic data, and even-more compelling map visualizations so you can tell your best story.
Enable ArcGIS map
ArcGIS maps are currently available in Power BI service, Power BI Desktop, and Power BI mobile. This article provides instructions for the service and for Desktop.
Enable the ArcGIS map in Power BI service (app.powerbi.com)
This tutorial uses the Retail Analysis sample. To enable ArcGIS Maps for Power BI:
From the top right section of the menubar, select the cog icon and open Settings
Select the ArcGIS Maps for Power BI checkbox. You'll need to restart Power BI after you make the selection.
Open a report in Editing view and select the ArcGIS Maps for Power BI icon from the Visualizations pane.
Power BI adds an empty ArcGIS map template to the report canvas.
Create an ArcGIS map visual
Watch Will create a few different ArcGIS map visualizations and then use the steps below to try it out yourself using the Retail Analysis sample.
From the Fields pane, drag a data field to the Location or Latitude and/or Longitude buckets. In this example we're using Store > City.
ArcGIS Maps for Power BI will automatically detect if the fields you've selected are best viewed as a shape or a point on a map. You can adjust the default in the settings (see below).
- Convert the visualization to an ArcGIS map by selecting the template from the Visualizations pane .
From the Fields pane, drag a measure to the Size bucket to adjust how the data is shown. In this example we're using Sales > Last Year Sales.
Settings and formatting for ArcGIS maps
To access ArcGIS Maps for Power BI formatting features:
Access additional features by selecting the ellipses in the top right corner of the visualization and choosing Edit,
The available features display across the top of the visualization. Each feature, when selected, opens a task pane that provides detailed options.
For more information about the settings and features, see Detailed documentation below.
- To return to the report, select Back to Report from the top-left corner of your report canvas.
Esri provides comprehensive documentation on the feature set of ArcGIS Maps for Power BI.
Four base maps are provided: Dark Gray Canvas, Light Gray Canvas, OpenStreetMap, and Streets. Streets is ArcGIS's standard base map.
To apply a base map select it in the task pane.
ArgGIS Maps for Power BI automatically detects the best way to show data on the map. It selects from Points or Boundaries. The Location type options allow you to fine tune these selections.
Boundaries will only work if your data contains standard geographic values. Esri automatically figures out the shape to show on the map. Standard geographic values include countries, provinces, zip codes, etc. But just like with GeoCoding, Power BI may not detect the field should be a boundary by default, or it may not have a boundary for your data.
Four map themes are provided. Location Only and Size themes are automatically chosen based on the fields you bind to the location and added to the Size bucket in the Power BI Fields pane. We're currently using Size, so let's change to Heat map.
|Location Only||Plots data points or filled boundaries on the map based on the settings in Location Type.|
|Heat Map||Plots an intensity plot of data on the map.|
|Size||Plots data points on the map based that are sized based on the value in the size bucket in the fields pane.|
|Clustering||Plot the count of data points in regions on the map.|
Symbol styles enable you to fine tune how data is presented on the map. Symbol styles are context sensitive based on the selected Location type and Map theme. The example below shows Location type set to Size and several adjustments to transparency, style and size.
Call attention to points on your map by adding pins.
- Select the Pins tab.
Type keywords (such as addresses, places, and point of interest), in the search box and select from the dropdown. A symbol appears on the map, and the map automatically zooms to the location. Search results are saved as location cards in the Pins pane. You can save up to 10 location cards.
Power BI adds a pin to that location and you can change the color of the pin.
Add and delete pins.
The Drive time pane lets you select a location and then determine what other map features are within a specified radius or driving time.
Select the Drive time tab and choose the single or multi select tool. Single select the pin for Washington D.C.
It's easier to select a location if you zoom in on the map (using the + icon).
Let's say you're flying into Washington D.C. for a few days and want to figure out which stores are within a reasonable driving distance. Change Search area to Radius and Distance to 50 miles and select OK.
The radius is shown in purple. Select any location to display its details. Optionally, format the radius by changing color and outline.
Reference layer - Demographics
ArcGIS Maps for Power BI provides a selection of demographic layers that help contextualize data from Power BI.
- Select the Reference layer tab and choose Demographics.
Each layer listed has a checkbox. Add a checkmark to add that layer to the map. In this example we've added average household income.
Each layer is interactive as well. Just as you can hover over a bubble to see the details, you can click a shaded area on the map to see the details.
Reference layer - ArcGIS
ArcGIS Online provides the ability for organizations to publish public web maps. Additionally, Esri provides a curated set of web maps through Living Atlas. In the ArcGIS tab, you can search all public web maps or Living Atlas maps, and add them to the map as reference layers.
- Select the Reference layer tab and choose ArcGIS.
Enter search terms and then select a map layer. In this example we've chosen USA Congressional districts.
- To see the details, select a shaded area to open the Select from reference layer: Use the reference layer selection tool to selection boundaries or objects on the reference layer.
Selecting Data points
ArcGIS Maps for Power BI allows three selection modes.
Change the selection mode using switch:
Select individual data points.
Draws a rectangle on the map and selects the contained data points.
Allows boundaries or polygons within reference layers to be used to select contained data points.
A maximum of 250 data points can be selected at a time.
Esri provides comprehensive documentation on the feature set of ArcGIS Maps for Power BI.
You can ask questions, find the latest information, report issues, and find answers on the Power BI community thread related to ArcGIS Maps for Power BI.
If you have a suggestion for an improvement, please submit it to Power BI's ideas list.
Managing use of ArcGIS Maps for Power BI within your organization
Power BI provides the ability for users, tenant administrators, and IT administrators to manage whether to use ArcGIS Maps for Power BI.
User options In Power BI Desktop, users can stop using ArcGIS Maps for Power BI by disabling it on the security tab in Options. When disabled, ArcGIS Maps will not load by default.
In Power BI service, users can stop using ArcGIS Maps for Power BI by disabling it on the ArcGIS Maps for Power BI tab in user Settings. When disabled, ArcGIS Maps will not load by default.
Tenant admin options In PowerBI.com, tenant administrators can prevent all tenant users from using ArcGIS Maps for Power BI by disabling. When this happens, Power BI will no longer see the ArcGIS Maps for Power BI icon in the visualizations pane.
IT Administrator options Power BI Desktop supports using Group Policy to disable ArcGIS Maps for Power BI across an organization's deployed computers.
|key||Software\Policies\Microsoft\Power BI Desktop</td>|
A value of 1 (decimal) enables ArcGIS Maps for Power BI.
A value of 0 (decimal) disable ArcGIS Maps for Power BI.
Considerations and Limitations
ArcGIS Maps for Power BI is available in the following services and applications:
|Power BI Desktop||Yes|
|Power BI service (PowerBI.com)||Yes|
|Power BI mobile applications||Yes|
|Power BI publish to web||No|
|Power BI Embedded||No|
|Power BI service embedding (PowerBI.com)||No|
In services or applications where ArcGIS Maps for Power BI is not available, the visualization will show as an empty visual with the Power BI logo.
When geocoding street addresses, only the first 1500 addresses are geocoded. Geocoding place names or countries is not subject to the 1500 address limit.
Is there any charge for using ArcGIS Maps for Power BI?
I'm getting an error message in Power BI Desktop about my cache being full
This is a bug that is being addressed. In the meantime, to clear your cache, please try to delete files at this location: C:\Users\AppData\Local\Microsoft\Power BI Desktop\CEF and then restart Power BI.
Does ArcGIS Maps for Power BI support Esri Shapefiles?
ArcGIS Maps for Power BI automatically detects standard boundaries like countries/regions, states/provinces, and zip/postal codes. If you need to provide your own shapes you can do so using the Shape Maps for Power BI Desktop (Preview).
Can I view my ArcGIS maps offline?
No, Power BI needs network connectivity to display the maps.
Can I connect to my ArcGIS Online account from Power BI?
Not yet. Vote for this idea and we'll send you an email when we start working on this feature.
More questions? Try asking the Power BI Community