Forum Discussion

CJenner's avatar
CJenner
Advocate I
11 years ago

more location data required?

Ever since the Launch, I had a map that worked using zipcode now, the same chart gives me the following error:   To create a filled map, the Location data should include Bing Map-supported geograph...
skiwii's avatar
skiwii
Advocate I
10 years ago

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.

andre's avatar
andre
Memorable Member
10 years ago

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