Power BI maps bug when too many places are displayed

[fmantov]

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 ZealandSwitzerland

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.

[fmantov]

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]

@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?

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

[fmantov]

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]

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