Forum Discussion
PowerBI map show correct location
Hi, i'm trying to show a map with a location, i have the following table:
I'm using just one line with Lat and Long because i'm just testing, i'll do something using Azure Stream Analytics to get this data, even so it'll be just one line. I have a Country, a Long, a Lat and an ID.
I've followed a tutorial, took the values from Google Maps, set the Long and Lat as their respective data fields, put the country on location, but even so my map looks like this:
Someone knows how can i solve this issue?
Not sure without having the file myself, but how about making sure the data type is a Whole Number (after importing the data) and then creating new columns that divide the numbers by 100000?
4 Replies
Your latitude and longitude values seem out of range. See this: https://msdn.microsoft.com/en-us/library/aa578799.aspx.
Yes i've seen this. In my excel doc the numbers are formated right, like -xx.xxxxx, -yy.yyyyy, but when i upload it to powerBI it changes to -xxxxxxx, -yyyyyyy
Any clue on what i can do? I can't seen to change it to the correct format.Not sure without having the file myself, but how about making sure the data type is a Whole Number (after importing the data) and then creating new columns that divide the numbers by 100000?
