City in a report displayed in two different places on two Power BI accounts.

[Anonymous]

Hi everybody,

I have encountered a rather strange problem with a report I have created. I'm using the map to show where our units are (city). I have a unit sold in Guadalajara, Mexico but as you know there is also a Guadalajara in Spain. Now, in my desktop report and cloud service it places the unit sold in the correct place (Guadalajara, Mexico). However, when I shared this report with someone else, on their BI account it appears that the location of the unit is in Guadalajara, Spain. Has this happened to anyone else? I would really appreciate any guidance you could offer.

Thanks in advance!

[v-yuezhe-msft · Accepted solution]

@Anonymous,
 

In Power BI, sometimes, even setting the data categories for mapping isn’t enough for Bing to correctly guess our intent. Some destinations are ambiguous because the location exists in multiple countries or regions. For example, there’s a Southampton in England, Pennsylvania, and New York.

Power BI uses Bing’s unstructured URL template service to get the latitude and longitude coordinates based on a set of address values for any country.

So, if your dataset doesn’t contain enough location data,you could add latitude and longitude values to your dataset which remove any ambiguity and return results more quickly.

 
Regards,
Lydia

[Phil_Seamark]

Hi @Anonymous

Try creating a calculated column that is the country and the city combined in the same field.  e.g. "Guadalajara, Mexico" and then use that field in the Location area of your visual.