Forum Discussion
Azure map reference layer not rendering all polygons
I am attempting to use Azure map visual. Specifically I have added a reference layer. I have uploaded a file, the problem appears to be that the Azure map visual is hitting some unknown, unpublished limit. When I use a geojson file with about 32k polygons for each US zip code, everything appears to be fine until about TX where a bunch of zip codes are not rendered. If I limit the geojson file to about 11k records, It appears to work as expected.
So it appears that there is some upper limit that when reached limits the data on the viz. But I want to see all 32k polygons, how can I get this to work?
16 Replies
could not find any such limit documented here
https://learn.microsoft.com/en-us/azure/azure-maps/power-bi-visual-add-reference-layer?tabs=upload
have you uploaded the geojson file for reference layer rendering? if that is causing an issue then can you host this. file in github and use that URL as source and check?
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
Yes, I have uploaded the geojson file and it renders as expected, just not completely. Hopefully these images will help demonstrate the problem:
This .geojson file has about 32k polygons, it renders most of them; but the west coast is missing a ton of zip codes.If I filter the .geojson file for CA only, you can see that the polygons are there:
Blue polygons indicate areas with data, greyish polygons are data that exist in the reference layer but not in the data.
OldDogNewTricks
can you upload the full json file to github. And Instead of uploading the file replace it with the URL of the file that you uploaded to github?
Hi OldDogNewTricks ,
Thank you for reaching out to Microsoft Community.The Azure Maps Power BI Visual can only perform geocoding on valid location data such as geographical coordinates, addresses, or place names. If no valid location data is uploaded, data layers that depend on geocoded locations, such as heat maps or bubble layers, don’t display on the map.
The data-bound reference layer appears on the map as long as the data column contains unique identifiers that match properties in the spatial file, but to ensure correct results, your data column must include valid geographic information.
Best Regards,
Chaithra E.Please see the message above with the images. I can get the data bound reference layer to work in Azure maps, but it does not render all polygons.
Hi tharunkumarRTK ,
Thank you for the update.
Since you're able to get the data bound reference layer to work but not all polygons are rendering as expected, this looks like a bug. we recommend raising a support ticket with Microsoft for further assistance.
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
Best Regards,
Chaithra E.
Hi OldDogNewTricks ,
We wanted to check whether the issue has been resolved with the help of our support team. If it has, we kindly ask you to share the solution here and mark it as the accepted answer so that other users can benefit as well.
If you still have any questions or need further assistance, please don’t hesitate to let us know. We’re more than happy to continue supporting you.
Thank you for your patience. We look forward to hearing from you.
Best regards,
Chaithra E.I just wanted to follow up to ensure that your issue has been fully resolved by our support team. If there are any outstanding questions or if you need further assistance with anything, please don’t hesitate to reach out. We’re always here and happy to help in any way we can.
Your satisfaction is important to us, and we want to make sure you have everything you need.
Warm regards,
Chaithra E.It has not been resolved yet, though I do have an open ticket. I believe the 30k limit is a product limitation that is not documented. There is documented limitation on the Azure viz of 30k, but not on the Azure reference layer.
Hi OldDogNewTricks ,
Thank you for your continued patience while we investigate the issue.
As noted, the 30,000 feature limitation is a recognized constraint across several Azure visualization tools particularly when rendering geospatial data and is intended to maintain performance and responsiveness for large datasets. Get started with Azure Maps Power BI visual - Microsoft Azure Maps | Microsoft Learn
We’d like to check in and ensure your concerns have been fully addressed. Could you please confirm if our support team has resolved the issue, or if there's anything further we can assist you with?
We're here to help and remain committed to finding a resolution.
Warm regards,
Chaithra E.Hi there,
- I am experiencing exactly the same issue. I have 33,755 polygons (lower layer super output areas) and some of them do not show. The data is there and it shows in mapshaper and qgis, but in azure map some are dropped? Is it because if a file is simplified, some geographies (features) are silently dropped by azure?
Yes, this is an Azure maps limitation. They are limited to 30k polygons (this is not specifically a limitation for reference layers; it appears to be for the viz itself), and there is no way to modify. MS's guidence was bacially, "don't use that many polygons".
Get started with Azure Maps Power BI visual - Microsoft Azure Maps | Microsoft Learn
Under limitations:
"How many data points can I visualize?
This visual supports up to 30,000 data points.
"
Apparently this applies to the reference map as well as the Power BI viz itself.Hi OldDogNewTricks ,
Thanks for the update. As there are no outstanding queries at the moment, we’ll go ahead and close this thread for now. If you have any additional questions in the future, please don’t hesitate to start a new thread we’re always here to help.
Warm regards.
