Forum Discussion

KPRZ057's avatar
KPRZ057
New Member
7 months ago

Azure Map Visual Blank

I was trying to upgrade my visual to the new azure map where i am using the a metric colum site address 

site_address_final = triallink_df[site_name] & ", " & triallink_df[address_line_1] & ", " &triallink_df[address_line_2] & ", " &triallink_df[zip_5] & ", " &triallink_df[town_city] & ", " &triallink_df[site_state] & ", " & "United States of America"
Intially it start to put up the bubble for the sites then post which it goes blank and final on full load it stays blank instead when i using azure map to other dataset it is working completely fine.There are 97k rows for these column.Can you help with this

 

Need Help

5 Replies

  • Mauro89's avatar
    Mauro89
    Super User
    7 months ago

    Hi KPRZ057,

     

    there is a limitation of 30k data points (see Get started with Azure Maps Power BI visual - Microsoft Azure Maps | Microsoft Learn) which can be used for this visual. Your 97k are therefore too much.

    Try to reduce the row count by filtering or aggregating your data. But to ensure this is the problem in your case I recommend filtering the row count below 30k and check again. After this is successful, check out a reliable solution for your data point reduction.

     

    Best regards!

    PS: If you find this post helpful consider leaving kudos or mark it as solution

    • KPRZ057's avatar
      KPRZ057
      New Member
      6 months ago

      In this there is a catch when i remove the legend for the competitor flag i am able to plot all the 97k sites but as when i add that it goes blank

  • krishnakanth240's avatar
    krishnakanth240
    Super User
    7 months ago

    Hi KPRZ057 

     

    Azure Maps works with structured location data instead a long text addresses. Try this order
    Latitude / Longitude | City + State + Country | ZIP + Country.

     

    In one of my recent project, have 35k rows where I concatenated the city, state, and country and used in 'Location' field. In your case you can test by filtering the data from the slicers you are providing in report.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 months ago

    Hi KPRZ057,

     

    Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to Mauro89 and krishnakanth240  for prompt and helpful responses.

    Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

     

    Best regards,
    Prasanna Kumar

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 months ago

    Hi @KPRZ057,

     

    Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

     

    Best regards,
    Prasanna Kumar