Forum Discussion
more location data required?
it doesn't matter what you call it if you read and follow my instructions above.
No, I'm not and know you why? Because I shouldn't have to. When I go out to a client I don't want to tell them that they have to do what you suggested when they are considering Tableu, Domo or Microstrategy. Obviously they changed the canvas but it's not good enough. My zipcode field- fyi - is at my most atomic level my my dimensional model based on Kimball princepals. So what value does your solution have? None! You know why? Because 90% of the "BI" Architects and Developers don't know what a true Kimball model looks like. So when I fixed the name, my problem was solved which is what most people would do.
Let me tell you something, most BI software companies are out there saying, you don't need to do anything. Just hook our software up and it will work. Those of us who are true Bi architects know the truth, and what's worse is people I inteview know a tool and don't know the theory behind DW or DM design. You can bet that the design I am hooking up to is pure Kimball.
Your suggestion is actually crap because you clearly have missed the point that this application, which I loved at first, is not ready. I have to go to a client next week and explain to them why there's no drill down, or the fact that OLAP isn't direct connection (and yes it makes a difference, and to the poster who said that who want this feature understand OLAP is a moron and I can give you a reason, email me privately and I'll show you why it's important and not about design or anything of the above) .
In the preview we didn't have to what you said, so ask yourself - why do I need to do that now when I didn't before? Don't change the rules half way through the game and telll me it's my fault.
- rxomi10 years agoRegular Visitor
I have to agree with CJ (maybe not in so many words) but this is really frustrating. I have added Country, Province, City to my dataset to make this map work, (my dataset only had lat & long at first) to fix this issue but at the end, I still get the message “More location data is required.” I also went the extra step (which I shouldn’t have to) and categorized all these fields accordingly. Still the same error message. Here is an example of how others do it so easily. Just plug in the following lat & long (or use your own) in the following website and you get it plotted. So why not PowerBI?
Lat: 49.372020
Long: -123.276460
Website: http://www.latlong.net/Show-Latitude-Longitude.html
- Anonymous10 years agoNot applicable
So I am getting the gist of this. I have 2 zip codes in the model, will have to pick just one and rename Zipcode. But I have another dataset with long/lat, and another with a full address. Are the expected field names documented anywhere so I don't have to use trial and error.
I agree we should not have to use desktop to do field type mappings, this should be in the web version. The error message could have more info too.
- amien10 years agoHelper V
I can't also get this working:
used : streetname housenumber, postalcode city, country
works perfecty in bing.com, but gives me a more location data required needed.
Just city works great