Forum Discussion
Issue in bubble map
Hi mihir0030
Thank you for the update. Since separating location data into fields like "Country" and "Postal Code" does not resolve the issue, this points to a deeper geocoding limitation. Bing Maps does not recognize "34295" as a valid postal code in France, so it tries to find the closest match, which can result in the bubble being placed incorrectly sometimes in Le Champ Beaubois, France, or even in Florida, USA, due to overlapping ZIP codes.
To address this, consider bypassing Bing’s text-based geocoding by using exact geographic coordinates. In Power BI, map "Latitude" and "Longitude" directly in the visual. It’s also helpful to keep a lookup table that connects codes to the correct city names, postal codes, and geographic coordinates. This approach helps ensure accurate and consistent location mapping for all users.
Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.
Hi v-karpurapud , we do not have latitude/longitude data in our semantic model.
Hi mihir0030
The ongoing issue with the bubble map misplacement, even after separating the location fields, appears to stem from limitations within Bing Maps' geocoding engine, which is used by Power BI. The code "34295" is not identified as a valid French postal code, causing Bing Maps to assign it to approximate or incorrect locations, such as Le Champ Beaubois in France or even a site in Florida, USA, due to overlapping ZIP codes. This mapping behavior is determined by Bing’s geocoding logic and cannot be modified directly within Power BI.We suggest submitting a support ticket to Microsoft for further investigation. Since the issue relates to Bing Maps’ handling of non-standard or ambiguous location codes, Microsoft Support may be able to recommend a more effective solution, such as custom geocoding options or backend adjustments.
You can submit a ticket through the Microsoft Power BI Support Portal:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Regards,
Karpurapu D.Hi mihir0030
We wanted to follow up and ask if you have submitted a support ticket. Could you let us know if the issue was resolved after creating the support case?
Thank You.