London map doesn't show boroughs

[Anonymous]

Hi, 

I've created an Excel file that contains geospatial information on NUTS 3 and LAU 1 level. It works for all regions but London. Instead of breaking the city up by borough, it creates a shape for all of London for boroughs such as Richmond upon Thames of City of London. I do get the borough boundaries for Southwark though. The boundaries are definitely correct in my original file as both Tableau and Alteryx display each individual borough.

Does it maybe have to do with naming conventions? So maybe PBI knows the City of London as City? But how would I know which names to use instead?

[v-juanli-msft]

Hi @Anonymous 

I would suggest you to provide Latitude, and Longitude  for the map visual so to get more exact location point.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for the link.

I've tried that (both as long/lat and uncategorised field), but it makes my shapes disappear altogether unfortunately.

[Anonymous]

I've downloaded an official template from here: https://data.london.gov.uk/dataset/excel-mapping-template-for-london-boroughs-and-wards and get the same results. How come Power BI doesn't recognise the boroughs and is there a way around it other than creating a topoJSON?