Dynamics Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

How to get convert Lat and Long to Address?

  • 1.  How to get convert Lat and Long to Address?

    Silver Contributor
    Posted Aug 18, 2017 05:15 PM
    Does anyone know how to convert latitude and longitude into a full address (Street, City, ST, Zip)?

    I have seen posts for the other way around, but not for what I need. I have a data set that only has the Street, Latitude, and Longitude. Looking to see if I can convert this in such a way to pull the City, ST, and Zip.

    ------------------------------
    Aaron Back, MCP | Sr. Microsoft Dynamics 365 (CRM) Consultant
    ACE Microtechnology
    ________________________________
    PBIUG Board Member
    PBIUG Liaison
    ------------------------------


  • 2.  RE: How to get convert Lat and Long to Address?

    Bronze Contributor
    Posted Aug 19, 2017 02:33 AM
    Hi Aaron, you could perform reverse geocoding that is the way to get an address starting from coordinates.

    To get it in Power BI, you should write a custom function that calls Google geocoding API and pass coordinates to the function as parameters.

    You could give you an example, but right now I'm traveling. You should wait a couple of days.

    Andrea Martorana





  • 3.  RE: How to get convert Lat and Long to Address?

    Gold Contributor
    Posted Aug 21, 2017 04:14 AM
    Hi, Aaron,

    I've used the very nice Google Maps APIs and it works as Andrea says... for the most part. If you're looking to get accurate addresses for, say, duplexes, you very well may only get the address of one side of the duplex, not the other. I know this because I've used my own address in a duplex as a test. I get the geo coordinates first and then do a reverse geo lookup. I get the unit next door. If I shave the latitude a tiny amount and retry, I get the duplex address just to the south.

    Best wishes on your CRMUG All Star nomination!

    Sincerely,

    ------------------------------
    Steve Erbach
    Business Analyst & MS Dynamics Platform Administrator
    WOW Logistics Company
    Appleton WI
    +1 920.687.5423
    ------------------------------



  • 4.  RE: How to get convert Lat and Long to Address?

    Bronze Contributor
    Posted Sep 09, 2021 03:20 AM
    Hi,
    can you help. i am looking for same solution

    ------------------------------
    Anubhav Mahule
    Lead consultant
    ------------------------------