Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Power Map supports several geographic formats and levels including:

  • Latitude/Longitude (formatted as decimal)

Lattitude and Longitude data

  • Street Address

  • City

  • County

  • State / Province

  • Zip Code / Postal Code

  • Country/Region

To plot your data, pick the columns that make up your geography from the field list, and specify the geographic level they represent. Power Map takes it from there and plots your data.

For example, Power Map automatically detects and matches the columns in this data set to the geography fields.

Data structure for Power Map

In this case, Power Map starts geocoding the data based on the street address, like this:

Geography and Map Level in the Task pane

After verifying that fields correspond to their geography levels in the Geography section and clicking Next, Power Map automatically starts plotting your data by using Bing. You’ll see progress on the status bar, and can make changes to the field list and the globe while Power Map resolves your geographic data.

Power Map status on the Bing Bar

If there are multiple geographic levels, you can quickly view your data at a different level on your map. Using our example, picking the Street level visualizes the data by street, like this:

Power Map showing data by street

Picking the State level visualizes the same data by state, like this:

Power Map showing data by state

Change geography fields

To change the geography fields that are shown on the map by default, you can pick different fields in the Geography list. They’ll automatically appear in the Geography and Map Level box, where you can verify and change their map level.

Common geocoding errors

Geocoding conflicts can occur during the geocoding process. For example, Power Map may show an error message to let you know it couldn’t map some geography fields. This might happen when there are several cities in different states that have the same name, such as Springfield.

Power Map and Bing will try to find a solution by looking at surrounding data to determine where the city in each row of your data might be located, checking for state, country/region, province, and other geographic fields. If additional data is available, the city appears on the map, but in some cases, rows will be skipped. To avoid such conflicts, you can try adding columns that provide additional data (such as Zip Code or Country/Region) so Power Map can use that information to resolve the location with better accuracy.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×