Distance Calculation between two locations

[Anam]

Hey, how do I use Google Maps API with Power BI in order to calculate the distance between any two locations on a map?

[Anonymous · Accepted solution]

Hi @Anam,

You can try to use web connect with google api to calculate the distance:

Distance Matrix API

How to call REST APIs and parse JSON with Power BI

If your data contains Latitude/Longitude, you can try to use power query to calculate the distance:

Use Power Query to Calculate Distance

Regards,

Xiaoxin Sheng

[robofski]

Saw a video on Youtube about this very thing the other day:

https://www.youtube.com/watch?v=IGr5oQLm0ls&t=461s