cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Map visualization limits and issues

I have an excel spreadsheet that I am testing out the map visualization with. the total dataset is less than 40K lines in 4 columns (Quarter-Year, State, Zip, and Value). When I import the data into the PowerBI desktop application and attempt to use the Map visualization, it gives me an error that the Zip Codes contain too many values (even though there are only ~7000 unique values in the Zip column)

 

Also - if I want to do a map by State, how do I get PowerBI to recognize that "PR" is the abbreviation for Puerto Rico and not the Brazilian state of Parana (there are other cases of this as well)

16 REPLIES 16
Highlighted
New Member

Re: Map visualization limits and issues

We're encountering a similar issue, though we're not doing zip lookup, rather the specific address.

Highlighted
Memorable Member
Memorable Member

Re: Map visualization limits and issues

Mapping can be a little flaky if you let it up to Bing to geocode everything. What you may want to do is to add a column to your dataset that will help Bing do a better job geocoding.

 

For example, if you have a column for a city and another column for a state, I would create a CityState column that would take Chicago and IL and turn it into “Chicago, IL”. You can enhance this further if geocoding still is not perfect by adding IF logic and turning PR into Puerto Rico. So if you have San Juan as a city and PR as a state, I would create a column that said “San Juan, Puerto Rico” and let service geocode that. My guess is that it would do a much better job.

Highlighted
Memorable Member
Memorable Member

Re: Map visualization limits and issues

I also wish that any "Too Many Values" or other warnings would just go away.  Charts should be smart enough to merge several dots into one if they are too close to each other. 

 

If the map will only show a sample of the zip codes, we don't know which zip codes are not being mapped so the chart becomes practically useless.  I cannot think of a single scenario where those warnings do anything other than confuse the user who is looking at the chart.

 

The only time when those warnings are useful is during development.  So maybe the solution is to show the warning during the Edit mode but not during the View mode.

 

 

Highlighted
Frequent Visitor

Re: Map visualization limits and issues

Seems clunky to have to add yet another column to my data when the tool is supposed to understand and use filters for geo-coding intelligently.

 

If the new column isn't stored in the DW, then every time end-users who are supposed to use the tool will run into the same problems.

Highlighted
Memorable Member
Memorable Member

Re: Map visualization limits and issues

Well, city names are not unique so if you city name is Paris, i would not expect the mapping engine to know which Paris it is. So adding a state to a city name helps with that. 

 

When drill down is back, one thing I would expect to improve would be for the map to remember what state I drilled into so that it can only show the cities in that state without me having to add the state to the city name.  Other than that, I think having a field in the model that uniquely identifies a location is probably the safest way to go about it.

Highlighted
Regular Visitor

Re: Map visualization limits and issues

What I did is concatenated Address, City, State, Zip and it plots points pretty well.  This is good for customer level but you will run into value limits.  Question is, what is the official limit?

Highlighted
Memorable Member
Memorable Member

Re: Map visualization limits and issues

I can't think of the source but for some reason I recall hearing that it was around 500.  Would love to know the official number...

Highlighted
Anonymous
Not applicable

Re: Map visualization limits and issues

Does anyone know why I can easily find location using the offical Bing Map when I can't seemt to find the same address using Bing Map via Power BI Map visualizations ?

 

I'm doing as most do I guess, that is I concatanate to get [Address & No - Zip code - City] and it seems to work >95% of the time (I want this to go up to close as 99.99%)

Highlighted
Regular Visitor

Re: Map visualization limits and issues

One thing to make sure of is to remove the hash symbol (#) from any address you pass in and concatenate.  Leaving it in there has caused problems for me.  You can remove at source or just filter it out in Power BI.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors