Forum Discussion
more location data required?
I tried naming my fields [Postal Code] and the American name of [Zip Code] but no cigar. I even tried a concatenation of City, Postal Code and Country in one field but again no luck. The only way I could get this to work was to concatenate the latitude and longitude together in a string with a comma separating the two.
Note that I my data is in Excel tables and not a cube. In SSAS at least you can define an attribute with a Geography type, but I doubt this will work.
skiwii - Coming in late to this conversation, but it seems like the trick that is missing is Data Categorization. I created a Enter Data query with some zip codes, doesn't matter what the column is called, mine was called Zips.
In the model, change the data categorization to "Postal Code". If you had Country, you would categorize it as "Country", etc.
Place the categorized fields in the Location area. See below:
skiwii you can now define Data Category in Power BI desktop much like you could in SSAS, so you can click on a field with Zip data and Categorize it as a Postal Code.
Now, for some reason, it seems like there is some sort of an issue happening from the geocoding perspective, i noticed that my states and cities are geocoded fine today, but states are fluky, so I am wondering if there is a bug in a service with geocoding zipcodes right now
