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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
helenah
Helper I
Helper I

Postal code areas on map

Hi,

 

I have postal code area information on several countries and I cannot seem to find a common way to map it in Maps. For example, Germany postal codes with two digits (https://en.wikipedia.org/wiki/List_of_postal_codes_in_Germany) or UK post codes with two letters (https://en.wikipedia.org/wiki/List_of_postcode_areas_in_the_United_Kingdom). For France, I was able to do this with format "FR, 66" and setting it as a County, However, same logic does not work for e.g. UK or Germany.

 

Is there any common way of showing the postcode area data on Bing map?

Is there any documentation on what levels of data Bing maps have per country (since it seems to differ)?

I have tried every possible format of 2-digit/letter zip code, country code and country name, in different orders, separated with comma or space, ... and selecting county, postal code, region, ... as data type.

 

Any help on the topic appreciated, even on single country level.

 

br,

Helena

4 REPLIES 4
NeossITAdmin
Regular Visitor

I found the best way to use this map was to use the lon and lan, it struggles every other way i've tried to use

 

Great Free Datasource below for Postcode data across globe.

https://www.aggdata.com/free/germany-postal-codes

 

helenah
Helper I
Helper I

Update: For UK, it seems to work if I have same format as France (e.g. GB, AB) and set it as "Postal code".

However, a common way would be great since I don't know how to show global / Europe level data on one map if one country requires the data to be shown as "Postal code" and the other as "County"...

@helenah

 

I don't exactly know what cause the difference in your case, just share something I've found.

The abbreviation such as FR-U, DE-BE can be recognized in Map and Filled Map if they're categorized as "state or province".


So for the problem in your case, the cause can be that your data violates some kind of geographic standard?

Another update - the above works for Map but not for Filled Map. Why is this?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.