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

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 identified, but with Lake county, Power BI incorrectly highlights Cook county, Illinois.

 

Geographic columns are categorized correctly, with the combined county and state column (Lake, IN) categorized as county. 

 

Here's a screenshot of "Lake, IN" appearing as Cook county, Illinois.

 

 

Below are county maps showing Lake county, Indiana and Cook county, Illinois:

 

 

 

Below is a side by side comparison of a Bing map (Left) and an Esri map (Right) with identical data. The Esri map highlights Lake county, Indiana correctly. 

 

 

I've tried numerous combinations (Spelling out Indiana instead of IN, adding the word county, etc.), and I have been unable to get Bing maps within Power BI to correctly identify this county. I then thought that maybe Bing Maps could be the problem, but if you search "Lake, IN" in Bing Maps in a browser, it returns the correct result.

 

I've created a small sample Power BI Desktop file that demonstrates the issue. You can download it here - https://t.co/ZYdtNaXHv4

3 REPLIES 3
v-ljerr-msft Super Contributor
Super Contributor

Re: Bing Maps Highlighting Wrong County

Hi @ckoester,

 

Thanks for the detailed explanation. I have reproduced the same issue with the latest version of Power BI Desktop(2.54.4970.761 64-bit (January 2018)) on my environment. I'll report this issue internally and post back if there's any feedback. Smiley Happy

 

Regards

v-ljerr-msft Super Contributor
Super Contributor

Re: Bing Maps Highlighting Wrong County

Hi @ckoester,

 

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

Highlighted
skowalski New Member
New Member

Re: Bing Maps Highlighting Wrong County

Using the suggested workaround is okay to a point. However, as soon as I add a field to "Legend", it will only display counties with Lat & Long. If I select "Show items with no data" for both Location and Legend fields, no counties are displayed.

 

The visual I'm creating is not very useful without use of the Legend field, and I don't want to try to get a Lat & Long for the 500+ counties I'm using.

 

How is correcting the Lake County data on your end fixed already? This post is almost a month old.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 317 members 3,168 guests
Please welcome our newest community members: