Create ArcGIS maps in Power BI
These visuals can be created and viewed in both Power BI Desktop and the Power BI service. The steps and illustrations in this article are from Power BI Desktop.
This overview is written from the point of view of a person creating an ArcGIS map for Power BI. Once a designer shares an ArcGIS for Power BI 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 Explore ArcGIS for Power BI.
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 for Power BI map on a mobile device, you can view and interact with it.
ArcGIS for Power BI supports Power BI Report Server in online environments only; it isn't supported in an offline environment.
GIS stands for Geographic Information Systems.
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 for Power BI offers enhanced mapping capability, demographic data, and even-more compelling map visualizations so you can tell your best story.
This tutorial uses Power BI Desktop and the PBIX Retail Analysis sample. ArcGIS for Power BI maps can also be created using the Power BI service.
- From the upper left section of the menu bar, select File > Open report.
- Find the Retail Analysis sample PBIX file saved on your local machine.
- Open the Retail Analysis Sample in report view .
- Select to add a new page to the report.
Create an ArcGIS for Power BI map visualization
To add a map to a report, follow these steps:
Select the ArcGIS for Power BI icon from the Visualizations pane.
Power BI adds an empty template to the report canvas. In this overview, we'll be using the Standard version included with Power BI. If you sign in to a valid ArcGIS account with the proper licensing, you'll have access to more features; for details, see the ArcGIS for Power BI online help.
From the Fields pane, drag a data field to the Location field, or drag coordinates into the appropriate Latitude and/or Longitude buckets. In this example, we're using Store > City.
ArcGIS for Power BI automatically detects whether 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 format the ArcGIS for Power BI visualization).
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.
You've created your first ArcGIS for Power BI map. Now, let's refine and format our map using base maps, location types, themes, and more.
Format the ArcGIS for Power BI visualization
To access ArcGIS for Power BI formatting features:
On the Visualizations pane, click the Format tab to view the formatting options.
ArcGIS map formatting options include:
- Layers: Change the title of the Layers list (ToC), turn the layers list on or off, anchor the list over the map, define the position of the anchored list. The Layers list is on by default and is available in the expanded map tools .
- Map tools: turn navigation tools on or off, lock the map extent in its current position, define the position of infographics cards on the map. Zoom in and Zoom out buttons are off by default.
- Location type: Specifying the country/region in which your data is located helps to improve the accuracy of locations on your map. If your data is in a single country/region, choose the country/region from the drop-down list. If your data is global, choose World.
- Search: Turn the Search function on or off, change the default color of the pin. Search is on by default and is available in the expanded map tools .
Edit an ArcGIS for Power BI map
After you add data to the map visualization, the map tools become available.
This tutorial shows only the features and options available in the Standard version of ArcGIS for Power BI. If you're signed in to a valid ArcGIS account with the proper licensing, you'll have access to more features.
To expand the map tools:
Click the Map tools button to expand the tools.
The map tools expand to show the available features. Each feature, when selected, opens a task pane that provides detailed options.
Esri provides comprehensive documentation on using ArcGIS for Power BI.
Change the base map
A basemap provides a background, or visual context, for the data in a map. For example, a basemap showing streets can provide context for your address data. Using the Standard account, four base maps are provided: Dark Gray Canvas, Light Gray Canvas, OpenStreetMap, and Streets.
To change the basemap, follow these steps:
Click the Basemap button to display the gallery.
Select the Dark Gray Canvas basemap.
The map updates using the new basemap.
For more information, see Change the basemap in the ArcGIS for Power BI online help.
Show map layers
In ArcGIS for Power BI, you work with geographic data through layers. Layers are logical collections of geographic data that are used to create maps; they are also the basis for geographic analysis.
To display the Layers list, click the Layers button in the map tools.
The Layers list displays each layer that makes up the map, and each layer has its own set of options to help you customize and work with the map. Different options appear in the menu depending on the type of layer selected; for example, you can change symbology and location type for a layer created using Power BI data—like the City layer you created for this example—but those options aren't available for reference or drive-time layers.
For more information, see Work with layers in the ArcGIS for Power BI online help.
Specify the location type
ArcGIS for Power BI uses its powerful geo enabling technology to accurately position location data on the map and automatically renders items as points or boundaries by default, based on the type of data. For example, a latitude-longitude coordinate is rendered as a point on the map, whereas a state field is rendered as a boundary, or polygon. You can change the way locations are rendered by specifying the location type.
Use the Location type feature to improve the accuracy of the locations on your map. You can quickly do this by choosing a country/region in the visualization's Format pane (expand the Location type category and choose the appropriate country/region), or access more options by using the full Location Type feature in the layer options pane.
The full Location type feature is accessible through the layer options menu and allows you to choose whether to represent your data as points or boundaries (polygons), in addition to specifying the country/region in which the data is located. Boundaries are typically defined as standard geographic areas such as countries, provinces, ZIP codes, and so on. If you choose boundaries and a specific country/region for your data locations, you can choose from a variety of standard boundaries, such as counties, census tracts, districts, or municipalities. Different location types are available for each country/region.
To modify your data's location type, follow these steps:
In the Layers list, select the data layer you want to work with.
Click the Layer options button and choose Location type.
Accept the default values to render the locations as points on the map and specify One country > United States.
For more information, see Specify the location type in the ArcGIS for Power BI online help.
Customize the map's symbology
ArcGIS for Power BI uses values in the Fields pane to intelligently determine how it should render locations on the map. The Symbology feature allows you to modify the default styling to better tell your story. You can choose a different map theme and customize the symbols and colors used to represent locations on the map. Different map themes and styling options are available, depending on the values you added to the map visual's Fields pane.
To change a layer's symbology, follow these steps:
In the Layers list, select the data layer you want to work with.
Click the Layer options button and choose Symbology.
The Symbology pane appears, with the Map theme category expanded.
Change the map theme
In this example, because we added values to both the Location and Size fields, the map uses the Size theme by default.
To change the map theme, follow these steps:
Choose some of the other map themes to see how your map changes.
Choose the Size theme.
For detailed information, see Change the map theme in the ArcGIS for Power BI online help.
If your map contains several layers, it can be useful to render layers with some level of transparency so that items on other layers are still visible.
To set the transparency value for the layer, follow these steps:
In the Symbology pane, expand the Transparency category.
Type a percentage in the text box or move the slider to the left (less transparent) or to the right (more transparent).
Symbol styles allow you to fine-tune how data is presented on the map. Default symbol styles are based on the selected Location type and Map theme, and the available styling options are different depending on which field wells contain values and the nature of those values.
To change the symbol style, follow these steps:
In the Symbology pane, expand the Symbol style category.
Change the symbol settings as desired. Choose a symbol shape, color, transparency, and outline color, thickness, and transparency. Expand the Symbol size category to change those options; different options appear depending on the nature of your data and the selected map theme.
The example below shows the map theme set to Size and several symbol style adjustments to transparency, style, and size.
When you're done setting styling options, close the Symbology pane.
Analyze your data
ArcGIS for Power BI provides several tools that allow you to discover patterns in your data and tell a compelling story with a map.
Analysis features include:
- Selecting locations on the map
- Searching for a specific address, place, or point of interest
- Adding a reference layer to provide more context
- Finding locations within a specified radius or drive-time area
- Adding cards that display demographic details about the area displayed on the map
ArcGIS for Power BI provides several different selection tools to help you select locations on the map. Different tools appear, depending on the type of layer currently selected in the Layers list.
To display the selection tools, follow these steps:
From the map tools, click the Selection tools button to expand the toolset.
There are four selection tools available; different tools may appear in the Selection tools menu, depending on the type of layer that is currently active. Because the map in this example contains only a data layer, only the Single select and Box select tools appear.
Tool Description Single select —This is a single-selection tool that can be used to click individual locations; it is the default selection tool. Press Ctrl and click to select multiple locations.Clicking data locations on the map selects them and triggers interactions with other visualizations.Clicking a pin or a location on a reference layer displays its tooltip. Box select —Drag a rectangle selector to select multiple locations or select individual locations by clicking them.As with the Select tool, clicking a pin or a location on a reference layer displays its tooltip.When the Box select tool is active, you cannot pan the map. Reference layer select —If you added a reference layer to the map, use this tool to select locations by clicking areas on the reference layer. Locations that are within a delimited area on a reference are highlighted; locations in other areas of the map are unavailable.This tool appears only if the map contains one or more reference layers and a reference layer is currently active. Drive-time select —If you added a drive-time area to your map, use the drive-time area selection tool to select data locations within the defined area.
Select one or more locations on the map. You can select a maximum of 250 data points at a time.
For more information, see Select locations on a map in the ArcGIS for Power BI online help.
Pin a location
Pin a specific address, place, or point of interest on the map. For this example, you'll search for the Pittsburgh International Airport.
To pin a location, follow these steps:
From the map tools, click the Search button to open the Search pane.
Type the keywords Pittsburgh international in the search box.
Keywords can include an address, place, or point of interest. As you type, similar recent searches or suggestions based on similar keywords appear.
From the results list, choose Pittsburgh International Airport and click Close.
A symbol appears on the map, and the map automatically zooms to the location. Pins remain in place on the map only during the current session; you cannot save a pinned location with the map. The pinned location also appears as a layer in the Layers list; you can rename the layer, show or hide it, or remove it from the map, as you can with other layers.
To change the color of the pin, expand the Search category in the map visual's Format pane and choose a new color.
The Search feature replaces the Pins feature previously available in ArcGIS for Power BI.
For more information, see Pin a location in the ArcGIS for Power BI online help.
Add a reference layer
Reference layers provide context for the Power BI data you're already displaying on a map. Reference layers can include demographic data, such as household income, age, or education. They can also include publicly shared feature layers available on ArcGIS Online that provide more information about areas surrounding the locations on your map.
Add a demographic layer
The Standard ArcGIS for Power BI account includes a curated selection of U.S. demographic layers that help contextualize data from Power BI.
To add a demographic layer, follow these steps:
From the map tools, click the Analysis tools button to expand the toolset.
Click the Reference layer button .
The Reference layer pane appears, displaying the Demographics tab and its selection of layers.
Scroll through the gallery and click Add on the thumbnail of the layer you want to add to your map.
For this example, find the 2016 USA Average Household Income layer and click Add.
The map updates to show the new layer.
Demographic reference layers are interactive; click an area to view a tooltip containing more information. You can also use the Reference select tool to select areas on the map that fall within an area on the reference layer.
Add a reference layer from ArcGIS
ArcGIS for Power BI allows you to search for publicly shared feature layers on ArcGIS, giving you access to thousands of reference layers that provide information about the areas surrounding the locations on your data layer. When you sign in to ArcGIS for Power BI using a valid ArcGIS account, you can search for content in your organization, your organization's groups, or public content. In this example, because you're using the Standard account, only publicly shared content appears in search results.
To add an ArcGIS reference layer, follow these steps:
In the Reference pane, click the ArcGIS tab.
In the search field, type USA Congressional districts and press Enter.
The gallery populates with several possible results.
Locate the USA 116th Congressional Districts layer and click Add.
The map updates to show the new layer.
ArcGIS reference layers are interactive; click an area to view a tooltip containing more information. You can also use the Reference select tool to select areas on the map that fall within an area on the reference layer.
Find nearby locations
You can use locations on your map—including a pinned location—as a starting point to find and select nearby locations on your map. For example, if you search for a particular place of interest, you can select locations on your map that are within a specified driving time or distance from that place.
In this example, you'll use the Pittsburgh International Airport you pinned earlier as a starting point to find locations within 100 miles of the airport. Use similar steps to find locations within a specified drive time.
To find locations within a specific driving distance from the point of origin, follow these steps:
From the map tools, click the Analysis tools button to expand the toolset.
Click the Drive-time button .
The Drive time pane appears.
Click the single select tool and, on the map, select the Pittsburgh International Airport location you pinned earlier.
From the Search area drop-down menu, choose Radius and specify a distance of 100 miles.
The map shows a circle surrounding the pinned airport location. The Drive time pane expands to show styling options for the driving distance area.
The driving distance area also appears as a layer in the Layers list; you can rename the layer, show or hide it, or remove it from the map, as you can with other layers.
With the drive-time layer active in the Layers list, use the Drive-time select tool to click the driving distance area.
Locations that fall within the search area are selected; unselected locations on the map appear smaller or become more transparent. Other visualizations are updated to reflect the selected locations.
For more information, see Find nearby locations in the ArcGIS for Power BI online help.
Add infographics cards
Like reference layers, infographics cards provide additional details about areas on the map. Infographics cards lay on top of the map and display specific demographic information about either the area immediately surrounding a selected location, or about the general area displayed in the current map extent. For detailed information, see Add infographics cards in the ArcGIS for Power BI online help.
Esri provides comprehensive online documentation on ArcGIS for Power BI.
To access the ArcGIS for Power BI online help from the visualization, follow these steps:
From the map tools, click the Settings button .
On the Settings pane, click the Help button.
Click OK on the confirmation window that appears.
The ArcGIS for Power BI online help opens in a browser window.
- Find answers to frequently asked questions on ArcGIS for Power BI online help.
- You can ask questions, find the latest information, report issues, and find answers on the Power BI community thread related to ArcGIS for Power BI.
- If you have a suggestion for an improvement, please submit it to Power BI's ideas list.
Manage the use of ArcGIS for Power BI within your organization
Power BI allows designers, Power BI admins, and user administrators to manage the use of ArcGIS for Power BI. The sections below outline the actions each role can take.
In Power BI Desktop, designers can disable ArcGIS for Power BI on the security tab. Select File > Options and settings and then select Options > Security. When disabled, ArcGIS will not load by default.
In the Power BI service, administrators can turn off ArcGIS for Power BI for all users. Select Settings > Admin Portal > Tenant settings. When disabled, Power BI will no longer display the ArcGIS for Power BI icon in the visualizations pane.
User Administrator options
Power BI Desktop supports using Group Policy to disable ArcGIS for Power BI across an organization's deployed computers.
|Key||Software\Policies\Microsoft\Power BI Desktop|
A value of 1 (decimal) enables ArcGIS for Power BI.
A value of 0 (decimal) disables ArcGIS for Power BI.
Considerations and limitations
ArcGIS 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||Yes, for designers signed in to a valid ArcGIS account with the appropriate add-on license. Consumers do not need the add-on license to view published content.|
|Power BI Embedded||Yes, for designers signed in to a valid ArcGIS account with the appropriate add-on license. Consumers do not need the add-on license to view published content.|
|Power BI service embedding (powerbi.com)||No|
|Power BI Report Server||Yes, in online environments only; not supported in a disconnected environment.|
*In mobile environments, you can view maps created using the ArcGIS for Power BI visualization included with Power BI (Standard account). Maps that contain premium content from ArcGIS are not supported in mobile environments.
In services or applications where ArcGIS for Power BI is not available, the visualization will show as an empty visual with the Power BI logo.
The following table compares the standard features available to all Power BI users to those available to signed-in ArcGIS users:
|Standard (included with Power BI)||With your ArcGIS account|
|4 basic basemaps||All Esri basemaps plus access to your organization's basemaps, including custom basemaps|
|3,500 locations per map||10,000 locations per map|
|10,000 locations per month||No monthly limit|
|10 reference layers that contain U.S. demographics||Access to all web maps and layers from your ArcGIS organization|
|Publicly shared feature layers in ArcGIS||Publicly shared feature layers in ArcGIS|
|Access to ArcGIS Living Atlas of the World maps and layers (feature services)|
|Curated gallery of U.S. demographics variables (7 categories)||Full access to the ArcGIS GeoEnrichment data browser, including U.S. and global demographics variables|