Forum Discussion

mjfulke's avatar
mjfulke
Microsoft Employee
9 years ago

Create Your Own Custom Map for Power BI

Hi, I’m sharing back with community here (I encourage you to do the same as you come across your own useful Power BI tips and recipes)   In this post, I will share how to create a custom map file t...
Show and Tell
Tips and Tricks
Leila's avatar
Leila
Regular Visitor
9 years ago

Thanks for the tutorial.
I have a question and would appreciate if u please care to answer. My map has 22 zones which is also visible when I look at the "map key" in Power BI (after doing what was suggested in the tutorial). However the tables it generates include only a 3-rows table that I cannot figure out what it is. 
How can I get the map keys to appear in columns so that I can correspont other sources like density to these 22 zone?

 

ps: If it can help to understand my problem better, this is the link to the site I get the map data from. 
https://www.google.com/maps/d/viewer?mid=1-6HQGXmwwew02zeDR5KpY1OA1mc&hl=en_US&ll=35.71139552629039%2C51.19023800000002&z=13

mjfulke's avatar
mjfulke
Microsoft Employee
9 years ago
Hello, All of the map keys should be visible in MapShaper.org. Click the info ("i") on the right menu and then select the different shapes. All of these columns should show up as keys in the Power BI shape map visual. The "name" column is the one you want to map your data to. NOTE: The Map Key dialog box is very skinny so you may need to scroll to the right to see the name column
  • hdunn's avatar
    hdunn
    Frequent Visitor
    9 years ago

    Thanks for posting this.

    I am able to upload my data into the shape map. 

    My issue is that my data was converted with over 500 polygons and it covers the whole Australia. It hangs the whole report while refreshing the map.

    I think this could be caused by the size of the map.

    Is there size limitation for a customised map, particularly for long road or large polygons with many vertex?

    Helen

     

    • Capstone's avatar
      Capstone
      Resolver I
      9 years ago

      I believe so as well as Im having the same problem for the last few days. My file sizes are around 25MB and power BI doesnt like it. I imported the statistical areas map of Australia and though it imports fine, you cant do much with it as it freezes and crashes. Hope they fix it.

      • hdunn's avatar
        hdunn
        Frequent Visitor
        9 years ago

        I initially tried Esri Map option. It generalised so much that you couldn't even recognise the area. 

         

        Wonder if anyone has used both maps successfully on the REAL spatial data, not just simple point data.

         

        I contacted Esri support, and was told that this product is not supported by Esri and advised to contact MS. I don't know who to contact in Microsoft to discuss both maps. Anyone has idea?

         

        I recommand there should a special discussion community of using maps.

         

        Helen

    • mjfulke's avatar
      mjfulke
      Microsoft Employee
      9 years ago

      My suggestion is to use mapshaper.org and use the "Simplify" feature.  You will find that by reducing the complexity of your shapes up to as much as 50-60% you can visually get about the same map.  For example, I have a map of all the counties in the U.S. which is approximately 3000 shapes.  The total file size is 1.25 MB.    It's not as much a Power BI problem but a PC/device issue trying to render lots of detailed Polygons.  Use mapshaper to reduce the detail of your shapes and it should render faster.

      • hdunn's avatar
        hdunn
        Frequent Visitor
        9 years ago

        Thanks for the suggestion. I will give it a try. Hopefully, it won't have the similar behavious as the Esri Map into which I published the same data and used in other GIS applications without problem. It was simplied on the fly when it loaded into the Power BI.

         

        Helen