Forum Discussion
Power BI Desktop Map and excel 2013
Questions on Power BI Desktop. New Dashboard\Report and I get data from an excel file (Name, Latitude, Longitude, Type and Value). When I click on the world map, it asks me for Location, Lege...
WillT
Community Admin
Community AdminHi Adrian. We use Bing to determine where to plot points, so we send them the values in the Location field to geocode. That gives us a lat/lon, but it's not always right (if you just send 'Paris', they return Paris, France rather than Paris, Texas for example). You can use lat/lon from your own data to correct this.
We do know about the issue where it's only corrected once you've put something in Values - you shouldn't need to specify that - and we're working on a fix. You can try creating a measure with a fixed value and put that into Values, then they should all appear the same size.
Thanks!
Hi WillT,
Thank you for coming back to me. How do you use Bing to determine where to send plot points?
I used Bing maps to manually copy all of the lat\long into a spreadsheet.,,
I also tried to change the Value from an excel value to a Measure = 1 but it still seems to show up on the Map using the Longitude as the value number. I would imagine its a mistake possibly.
Can you also tell is the Online version of PowerBI the same as the Desktop version or should I try both?
Thank you