Forum Discussion

residentx's avatar
residentx
Helper IV
3 months ago

PowerBI & Spatial Data Questions

I used Powerbi in the past and had good experiences. I've noticed changes and I'm spending the weekend trying to learn the new Powerbi. 

 

This is what I'm trying to investigate. I need to create bounded borders of Zipcodes worldwide inside of counties. I'm starting with the US. Moving along, I have this dataset for Maryland but when I import the table, PowerBI classifies my zipcode list as a count list.  How do I turn off the count feature and restore my original zipcode list dataset? 

 

I did this on Filled and Azure Maps

 

Thanks in advance for your comments

 

 

16 Replies

  • I found how to change the zipcodes but I cannot find how to turn on the maps settings in powerbi. I searched maps but nothing comes up. Asking me to create an Azure account is not an option for me. 

     

     

     

    • residentx's avatar
      residentx
      Helper IV

      Can I ask some new questions? 

       

      1. I searched "Maps" in Powerbi and Azure but nothing came up in the tenants to turn on the maps features. 

       

       

      • residentx's avatar
        residentx
        Helper IV

        2. PowerBI used to be a part of Office 365. Has it been separated? I installed the desktop version on my local machine but I guess that cannot access the map services. 

         

        3. Why would I used/sub this service when I could just sub a service that had it all in one package? ESRI now has a free account and it works in Excel. Honestly, this was the only reason I used powerbi. If I could do everything in Excel I would. PBI is not supported on any other platforms except for Microsoft. What is the rationale for some of these decisions? 

  • If you are trying to show bounded borders then zip codes are not enough. You must use multipolygons. There are free shape map files from GADM.org but they may not be updated.