Skip To Content

Prepare your data

Geocoding is the process of transforming a description of a location (such as a pair of coordinates, an address, or the name of a place) to a location on the earth's surface.

Esri provides resources that enable you to locate addresses, cities, landmarks, business names, and other places in more than 100 countries around the world. ArcGIS Maps for Power BI uses the ArcGIS World Geocoding Service to locate point features (such as addresses, United States cities, and world cities) and the ArcGIS GeoEnrichment Service to locate boundary features (such as ZIP Codes, states, provinces, and countries).

When you add data to a map from Power BI, choose the location type that best represents your information. Location information from your data is used to create a relationship between your business data and the specified location type. Although ArcGIS Maps for Power BI has functionality that provides a location on the map based on the available location data, there are a few ways you can prepare your data before you add it to the map to help ensure accurate results every time.

Location types

Follow these best practices to accurately map your data.

Use the appropriate location information in the Location field

The following types of information are allowed in the Location field:

  • Address information—Depending on the geographic region of your organization, address data can be composed of any of the following: address, neighborhood, city, subregion, region, state, province, postal code, United States ZIP Code, country, and so on. The more address elements your data contains, the more accurate your results will be.

    When you geocode addresses, you can add a maximum of 1,500 point features to an ArcGIS Maps for Power BI visualization.

    The Location field well accepts only a single value. Because of this, if your address information is contained in separate columns, it's important to combine the information into a single, comma-separated location column. You can then place the combined column data in the Location field well to add data to the map.

  • Standard administrative boundaries—When you use standard administrative boundaries in the Location field, ArcGIS Maps for Power BI first searches for specific settings in the column's Data Category metadata; if the data is categorized as State or Province, Postal Code, County, or Country/Region, ArcGIS Maps for Power BI uses a standard geography query to locate the items on the map.

    If no metadata is found, ArcGIS Maps 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.

    Administrative boundarySupported keywords

    United States state

    state, states

    United States ZIP Code

    zip, zips, zipcode, zipcodes, zip code, zip codes, postal code, postal codes

    United States county

    county, counties

    World city

    city, cities

    World country

    country, countries

    If a keyword is found, ArcGIS Maps for Power BI uses the ArcGIS GeoEnrichment service to locate polygon features on 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 Maps for Power BI cannot find recognizable metadata or keywords, it sends the data in text form to the ArcGIS World Geocoding Service to try to locate point features. In many cases, this results in inaccurate findings because there is not enough information to determine the locations. Use the Location type pane to specify the parameters for the locations.

Choose the boundary location search method

When you're mapping boundaries, such as states or other standard administrative boundaries, ArcGIS Maps for Power BI uses a closest-match search method to locate the areas. This is the default behavior and is more forgiving in terms of spelling or other errors in your data. Use Closest match if you believe your dataset may contain spelling errors (such as Claifornia instead of California), if there are multiple possible English spellings of your location names, or if you're not sure of the exact spelling used by Esri's data services. This option is not recommended for codes, as it may return incorrect geometries. The following are examples of data that work well with the Closest match search:

  • Country names
  • Brazil states
  • U.S. states
  • Any data that may contain spelling errors or special characters

If you're using codes or abbreviations to locate boundaries, or when you're confident that the spelling in your dataset is correct and matches that used in Esri's data services, use the Exact match search method. For example, use Exact match for the following data:

  • ZIP Codes
  • U.S. state abbreviations
  • ISO three-letter country codes (ISO 3166-1 Alpha-3)
  • Geometry names that have a single English spelling and that you're sure are accurately spelled in your dataset (California, for example)

Locate postal codes

When you use ZIP Codes or postal codes in the Location field, ArcGIS Maps for Power BI searches for specific settings in the column's Data Category metadata to identify the location type and accurately map it. When you're mapping locations by ZIP Code or postal code, it's important that you properly identify the data, depending on the format of the codes.

When postal codes are represented as codes or IDs, for example, 92374 or CF, categorize your data as Postal Code. Doing so allows ArcGIS Maps for Power BI to recognize the data as codes so that it can accurately map the features.

If a postal code is represented as a full name such as Cardiff, however, setting the metadata to Postal Code may generate inaccurate results. In these cases, set the metadata to Uncategorized and specify a column name that ArcGIS Maps for Power BI can correctly identify using recognized keywords, such as ZIP Code or Postal Code. Alternatively, use the Location type pane in ArcGIS Maps for Power BI to set the location type as a postal code category for the appropriate country for your data.

Use specific latitude and longitude values

Latitude and longitude values represent an x,y coordinate location on the map. You can map x,y coordinate data using the World Geodetic System 1984 (WGS84) coordinate system. In this system, latitude (y) values range from -90 to 90, and longitude (x) values range from -180 to 180.

Create a separate Location column in your data

Because the Location field can contain only a single value, it's best to create a new column in your dataset that combines all the address information (such as address, city, state, and ZIP Code) into a single, comma-separated values column that you can then use to add location-based information to your map.

Note:

Convert address and ZIP Code values to text format (Format: Text) before concatenating columns.

Using the Power BI Desktop Report Editor on the Modeling tab, in the Fields pane, click More next to the dataset you want to edit and choose New Column. Create a custom DAX formula that combines fields from multiple address columns into a single column. For example, to combine Address, City, Province, and Postal Code columns, your formula should look something like this:

Column = [Address] & ", " & [City] & ", " & [Province] & ", " & [Postal Code]

Give your new column a name that lets you easily identify it as your combined location data.

Data types, formats, and categories

The subsections below contain additional information regarding ArcGIS Maps for Power BI and data.

Categorize your location fields

To help ensure that ArcGIS Maps for Power BI accurately geocodes your data, specify the data category for each of your fields. Using the Power BI Desktop Report Editor, choose the table you want to modify. On the ribbon, click the Modeling tab. Select a column in the table and choose the appropriate category from the Data Category drop-down menu. For example, a U.S. state column should be categorized as State or Province; for a world country column, choose Country/Region; for ZIP Codes, choose the Postal Code category; and so on. If you've created a combined location column, choose the Address category.

Desktop data categories

For columns that contain location data, set the Default Summarization option to Do Not Summarize.

Use text values

Columns in your dataset that will be used for location (ZIP Codes, for example) should be formatted as textual values, not numerical values. If your data contains a number that includes a leading zero, as is common with ZIP Codes, some software packages interpret these fields as numerical values and strip out the leading zero, changing the original value. Formatting such columns as text ensures that your data remains accurate.

Desktop data types

Use time formats

ArcGIS Maps for Power BI supports several different date and time formats as listed in the table below. If you use a format not listed here, ArcGIS Maps for Power BI tries to match the format to an equivalent one; for example, 30‑Dec‑1997 will display as 30 Dec 1997. If there is no equivalent format, ArcGIS Maps for Power BI uses the default MM/DD/YYYY HH:MM: AM/PM (12/30/1997 6:00 PM).

For best results, use the Power BI modeling tools to set your date and time formats before you add data to a map.

ArcGIS Maps for Power BI supports the following date-time formats:

Date-time formatExample

MM/DD/YYYY

12/30/1997

Month DD, YYYY

December 30, 1997

Day Month (short) YYYY

Tuesday, Dec 30, 1997

Day, Month DD, YYYY

Tuesday, December 30, 1997

MM/DD/YYYY HH:MM AM/PM

12/30/1997 6:00 PM

MM/DD/YYYY HH:MM (24hr)

12/30/1997 18:00

MM/DD/YYYY HH:MM:SS AM/PM

12/30/1997 5:50:50 PM

MM/DD/YYYY HH:MM:SS (24hr)

12/30/1997 17:59:59

Month YYYY

December 1997

Month (short) YYYY

Dec 1997

YYYY

1997

HH:MM:SS AM/PM

5:59:59

HH:MM:SS (24hr)

17:59:59

HH:MM AM/PM

5:50 PM

HH:MM (24hr)

17:59

Number of features supported

When you're creating a map, it's easy to get carried away and try to add a large amount of data to the map. It's important to keep in mind that plotting too many individual features can lead to viewer confusion and frustration, and the resulting map may not provide a clear picture of your business data. In addition to creating a map that's difficult to interpret, trying to geocode a large number of rows to a map may negatively impact the performance of ArcGIS Maps for Power BI.

Plus subscribers

  • Using address information in the Location field: 5,000
  • Using longitude and latitude values in the corresponding field wells:
    • Chrome, Safari, Firefox, or Microsoft Edge: 30,000
    • Internet Explorer 11: 10,000
  • Using a standard administrative value in the Location field: 15,000

Included with Power BI

  • Using address information in the Location field: 1,500
  • Using longitude and latitude values in the corresponding field wells:
    • Chrome, Safari, Firefox, or Microsoft Edge: 30,000
    • Internet Explorer 11: 10,000
  • Using a standard administrative value in the Location field: 15,000

Note:

Because of hardware and browser limitations, performance may vary when you render polygon features such as ZIP Codes, counties, or block groups, for example. To mitigate problems, ArcGIS Maps for Power BI restricts the maximum number of features supported. In Power BI Desktop and in Chrome, FireFox, Safari, and Microsoft Edge browsers, the maximum number of polygons is 15,000. In Internet Explorer 11, the maximum is 5,000. This is a known issue that will be resolved in a future update.

An ArcGIS Maps for Power BI visualization can contain a maximum of 1,024 data columns.

For details about address and location fields, see Location types.