Incorrect UK counties in Bing Maps for Power BI and Excel

Jim Blair 0 Reputation points
2025-03-02T08:03:44.1533333+00:00

The UK counties in Bing Maps for Excel and Power BI are not accurate, and there are multiple issues. This has been reported as far back as 2012.

If you create an Excel table with three columns: Country (which must be UK), County, and Units, and create a map from this data, it is far more accurate than creating a Geography table. Nonetheless, there are still gaps.

e.g. Leicester, Leicestershire, Cumbria, Stoke-on-Trent, Staffordshire, York.

Do you know if there are any plans to fix this?

To fill the gaps manually, it would be useful if Microsoft provided a list of the names they use, e.g., York. I have tried mapping to York, City of York and York Town with no success, but it's just guesswork without a definitive list.

Many thanks.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,812 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.