March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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 🙂
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
133 | |
90 | |
88 | |
64 | |
58 |
User | Count |
---|---|
202 | |
137 | |
106 | |
70 | |
68 |