Re: Open Google Maps with lat, long link in BI mob...

Anonymous · ‎04-29-2019

Hi,

I have a mobile app with a table of lattitude and longitudes. Is there anyway to link the table to google maps - ie: have the user click a latitude and longitude which then opens the location in google maps.

The end goal is to create a map navigation from the user's current location, to the lat long in the table. I'm not sure that the map functions in power BI can do this?

Thanks!

AKMash · ‎09-27-2019

Hi Jkilb,

If you have the latitude and longitude as data in two separate columns you can create New Column with the following function:

Google Maps Link = CONCATENATE("https://www.google.com/maps/?t=k&q=",CONCATENATE('Column1'[Latitude],CONCATENATE(",",'Column2'[Longi...])))

'Column1'[Latitude] - is the column contains the latitude

'Column2'[Longitude] - is the column contains the longitude

It will create url's in the below form:

https://www.google.com/maps/?t=k&q=51.00xxxxx,0.11xxxxxx

Once you click on it it will pop up the google maps on the location of the data.

You can then transform the url's into icons

I hope this helps.

AKMash

v-yuta-msft · ‎05-09-2019

@Anonymous ,

Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

Regards,

Jimmy Tao

Anonymous · ‎05-21-2019

Hi,

Thank you for responding. Unfortunately it does not answer my question. I followed the link, read the guide and watched the video. It looks like arcGIS has a feature to illustrate "drive time" from a pinned location, but it does not appear to have the cpability of navigating you from your GPS location, to a desired location. If I could simply have Microsoft Power BI open the lat and long in google maps, google maps would locate the lat and long and direct you itself.

Thanks again for your help.

Justin

@v-yuta-msft