Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Power BI maps bug when too many places are displayed

Hello, I'm playing with MaxMind database worldcitiespop, a database that has a record for all cities in the world.

I know, more than 3M eneteries is too much, but the problem seems happening just with a few thousands.

 

I have no problem listing more than 4000 cities for New Zealand or Switzerland:

 

 


New ZealandNew ZealandSwitzerlandSwitzerland

 

 

 

 

 

 

 

 

 

 

 

Australia.PNGFrance.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Problem starts with Australia, 20,000: location are all listed down a certain parallel:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

France 60,000: same problem

 

 

 

 

 

 

 

 

 

 

 

 

And so on with, Italy, United States, Spain, Mexico or whatever. After a certina limit of pins the map just cannot hold it.

I found the same problem with ALL Custom Visual maps except for GIS.

 

 

 

 

Status: Needs Info
Comments
fmantov
Regular Visitor
You can test it with the same MaxMind database https://www.maxmind.com/en/free-world-cities-database if you import it to SQL Server
v-haibl-msft
Microsoft Employee

@fmantov
 
I cannot repro the same issue with latest June 2017 version of Power BI Desktop. Please refer to my screenshots below.

If issue persists on your side, could you please share your PBIX file to me through online file service like OneDrive?

 

Power BI maps bug when too many places are displayed_1.jpgPower BI maps bug when too many places are displayed_2.jpg


And we suggest to use DataCategory and geo-hierarchies in Power BI with following details.
 
1. Customer should use a geo-hierarchy to help with geocoding, introducing at least a Country column. Then drill down from Country to Province using the "fork" drill icon (expand all down in the hierarchy) to preserve the full hierarchy. 

 

2. Customer should also use the Data Category. Click the modeling icon at left, select the column (e.g. Province), and using the Data Category drop-down choose "State or Province". Same with country column, but choose "Country / Region".

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
fmantov
Regular Visitor
Hello, here is the file; https://vistaentertainment-my.sharepoint.com/personal/francesco_mantovani_vista_co/_layouts/15/guest... I was using Latitude and Longitude on Power BI for Geocoding so no street, zip code or country
fmantov
Regular Visitor

Here is another database that makes Power BI crazy: https://www.maxmind.com/en/free-world-cities-database