Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Bing Maps Highlighting Wrong County

Bing maps in Power BI Desktop and the Power BI Service cannot seem to correctly identify "Lake, IN", which is a county in the state of Indiana, USA. Every other county in Indiana is correctly identif...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

I got feedback from the Product Team:

 

FYI, I had this reply from Bing team: 

For the Lake County, IN issue, looks like it is a data bug and our Geocoding backend team is pushing the data team to get a fix for this.

Until then the user can try the workaround I suggested.

 

There is a workaround for this though which you can suggest - provide lat/long for locations Bing is wrong about. I've attached "With lat long.pbix" that shows how this is done. But basically, add Latitude and Longitude columns and enter values for some locations (Lake County in the file is 41.44,-87.38) but not for others that Bing gets right. In the map set Location, Latitude and Longitude roles (use Average for Lat and Long) and make sure to turn on "Show items with no data" in the Location role (this is on the dropdown menu for that role).

 

Regards

jiawenwei2016's avatar
jiawenwei2016
Regular Visitor
6 years ago

Hi,

 

I'm having the same problem with the map. I'm trying to point NY state counties. The map works fine when it's a boundary map. But when I want to use the point map with size and color, it kept marking counties weirdly. For example, Monroe, NY, which is very up north in NY got marked almost down to NY city.

 

I'm using Arc GIS. The column I'm putting into Location is formated as 'County, State', Eg. Livingston, NY.

 

I wonder if this is because of the same bug. And if there is any alternative solution (other than using lat and long, since it would make the tooltip looks confusing).

 

Thanks!