Azure map reference layer not rendering all polygons

[OldDogNewTricks]

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?

[v-echaithra]

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.

[v-echaithra]

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.

[OldDogNewTricks]

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.

[v-echaithra]

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.

[v-echaithra]

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.

[OldDogNewTricks]

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.

[v-echaithra]

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.

[tharunkumarRTK]

@OldDogNewTricks 

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!

[OldDogNewTricks]

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.

[tharunkumarRTK]

@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?

[OldDogNewTricks]

I cannot, I tried to upload the file to GitHub, but it is too large.  I did upload the CA version of the .geojson file to GitHub, because it is smaller, but that file did NOT work when I provided the URL (I get a "unable to load reference layer" notification). 

I can get the exact same file to upload in local Power BI Desktop and render just fine.  Why would it work any differently if being accessed from GitHub (URL) vs a local file upload?

[tharunkumarRTK]

@OldDogNewTricks 
As I mentioned in my previous message, in the documentation there is no mention about file size limit. So I am not sure how large the file size can be. So I suggested you to check if if it works with file URL rather than uploading falt file. 

[tharunkumarRTK]

May be you can consider raising a microsoft support ticket to find the root cause