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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
zzzz_Worker
New Member

UK Postcodes that originally were being plotted on Bubble Map no longer work

I am mapping where properties are using its postcode in Map functionality in Power BI. The postcodes I were using were all working perfectly last week but now only a few of them are being mapped. I am using a full postcode eg. CM24 1RL. Despite making no changes to the data when I refreshed the report most of the postcodes were not being mapped. I have tried concatenating the postcode and the country but then the postcodes that were mapping are not mapping at all. I have also tried converting the data category of the colum to "Postal Code" and that hasn't made a difference. 

 

Please Help 🙂

1 REPLY 1
v-heq-msft
Community Support
Community Support

Hi @zzzz_Worker ,
Based on your description, first of all, even though you mentioned that no data was changed when you refreshed the report, it's worth noting that there may be spaces for placeholders before and after the data. This can lead to inconsistent formatting of the coding. Ensure that the data in the Zip Code column is formatted consistently and correctly.Power BI relies on Bing Maps for geocoding, and sometimes even minor inconsistencies in the data can cause issues. After verifying the data format, try refreshing the data source and the Power BI report.
Second, if specific zip codes are still causing issues, consider using latitude and longitude coordinates for those locations. This method bypasses the geocoding process and provides more accurate mapping. You can find latitude and longitude data for UK zip codes through various online services.
You can refer to the following documents for more tips on using maps
Tips and tricks for creating reports in Power BI - Power BI | Microsoft Learn
Tips and Tricks for maps (including Bing Maps integration) - Power BI | Microsoft Learn

Tips & Tricks To Build The Best Map Visualizations... - Microsoft Fabric Community

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.