Note:
Some workflows may require specific privileges. For more information about user types, roles, and privileges, see the Accounts topic.
ArcGIS for Microsoft 365 matches locations in the data to locations on a map. The more you organize and prepare the data before you add it to the map, the more accurate the map results will be. See Data and geocoding to learn more about data.
When you add a data layer to a map, you choose the location type that best represents the information. Location information from the data is used to create a relationship between the data and the specified location type. Although ArcGIS for Microsoft 365 includes functionality to provide a location on the map based on the best available location data, preparing and organizing the data to align with expected location types helps ensure greater accuracy.
Location types
The following location types are used:
Location type | Value | Description |
---|---|---|
Coordinates | Latitude, Longitude |
|
Address | Address |
|
Neighborhood | ||
City | ||
Subregion | ||
Region | ||
State | ||
Province | ||
Postal code | ||
United States ZIP Code | ||
Country | ||
| ||
Standard administrative boundaries | See the Standard administrative boundaries section below. | |
Standard administrative boundaries
When you use standard administrative boundaries in the Location field, ArcGIS for Power BI first searches for specific settings in the column's data category metadata. If the data is in the State or Province, Postal code, County, or Country/Region category, ArcGIS for Power BI uses a standard geography query to locate the items on the map.
Note:
In some cases, a location, such as a ZIP code, may be associated with nonresidential post office boxes or related nonresidential services. These locations do not have boundaries associated with them, and the GeoEnrichment Service does not maintain demographic data for this type of location. If you are creating a map using nonresidential locations, use the Points location type. Using the Boundaries location type will result in errors during geocoding.
If no metadata is found, ArcGIS for Power BI searches for supported keywords in the name of the data fields that correlate to standard administrative boundaries. The following table lists the standard administrative boundaries and related keywords. Keywords are not case sensitive.
Location type | Supported keywords | Shape type |
---|---|---|
Address | city, cities, addr, address, street, town, capital | Point |
United States state | state, states | Polygon |
ZIP code | zip, zips, zipcode, zipcodes, zip code, zip codes, postal code | Polygon |
United States county | county, counties | Polygon |
World city | city, cities | Point |
World country | country, countries | Polygon |
If a keyword is found, ArcGIS for Power BI uses the ArcGIS GeoEnrichment Service to add polygon locations to the map. For a complete list of supported countries, see GeoEnrichment coverage.
Administrative boundaries are added to the map as polygons, which represent both the shape and the location of the place.
If ArcGIS for Power BI cannot find recognizable metadata or keywords, it sends the data in text form to the ArcGIS Geocoding service to find point locations. In many cases, this results in inaccurate findings because there is not enough information to determine the locations. Use the Location type tab on the Layers pane to specify the location parameters.