I can't create a map using latitude and langitude data

[ManuelEspitia]

Hello everyone:

I'm trying to map the clinics in Bogota. I already have latitude and longitude of each, but once I uploaded them to power BI I don't work the map. I don't know if it's because of the data type in these columns (Lat and Long).

I imported latitude and longitude data from google maps, using an add on (geocode for awesome table) from google sheets. It gave me the result of the first image. But once I copied them in excel to upload them to power bi changed the format to number. I tried to change the custom number format but I'm not sure what it is. I've used several of HHMMSS but I always get it as a result (second image). In the excel preview none of the custom formats seem to convert it to the original Lat and Long format (first image).

In Power Bi I already categoryed as Lat and Long each column and it is formatted as a decimal number. But it doesn't come out on any map, it's not filled, it's not arcgis, it's not a map. In Whole number format it doesn't work either.

You know what I should do in this case?

[amitchandak]

@ManuelEspitia , is these lat , log value format is correct? Just check that they were not formatted as a number in excel/Source.

Just put one of the last long on some location finder and check that it is correct

[Greg_Deckler]

@ManuelEspitia - Are you connected to the Internet? I know, dumb question. Can you share some of the lat/long coordinates as text so that I can test?

[ManuelEspitia]

Here are some:

4.7501645	-74.0654529
4.7080812	-74.1045479
4.6665894	-74.0687454
4.5829583	-74.1058526
4.6860735	-74.0566615
4.6153927	-74.1730139
4.6776983	-74.0572483

I took those from the google sheets file. The problem I think is because of the format in which they are transformed once I pass them to an excel file (they are left in number format). I've tried with general format and some custom ones but I can't get them to look like the ones above. These are once copied to excel.

47501645,00	-740654529,00
47080812,00	-741045479,00
46665894,00	-740687454,00
45829583,00	-741058526,00
46860735,00	-740566615,00
46153927,00	-741730139,00

Thanks for the help.

[v-xicai · Accepted solution]

Hi @ManuelEspitia ,

You may copy this data into Text document, which will keep the data format,  and then copy the data of text document into excel . After that, you may connect to the google sheet again. Set the data type of latitude and longitude as "Decimal number", and set the Category as "Latitude" and "Longitude", and set the aggregation as "Don't summarize". It will display result as below based on my test using your data.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CNENFRNL]

Hi, @ManuelEspitia , pls refer to an old post on the similar issue of mapping lat/long to see if it helps,

https://community.powerbi.com/t5/Desktop/Latitude-and-Longitude-not-plotting-on-MAP/td-p/491685

PS, I tried the following mockup and it works well in power bi map viz.

City	Lat	Long
A	4.5042340	-75.8146945
B	4.5094110	-75.7482540
C	4.6971197	-75.3346631
D	4.5592924	-75.9481338
E	4.5464602	-75.0389327
F	4.5597254	-75.7328735
G	4.5599204	-75.6704905