Forum Discussion
How to specify bulk amount of data in Origin? Distance Matrix API
I do have a CSV file sitting on my local machine that has an address, city, state, and zip code of more or less 5,000 employees.
and the same information for our 4 sites in the US.
My Intent is to calculate the distance and duration from an employee's home address to our office.
I have my API Key already . Trying to follow the Overview | Distance Matrix API | Google Developers
but I don't see any specific way to have those 5k employees' home addresses put in as part of the URL link that I will use in Power BI. I saw a video from Ruth ( Curbal ) (24) #34 Calculate the distance between two points/locations/coordinates in Power BI - YouTube.
Which I am kinda lost on how to.
I want to achieve is make that CSV file as part of Origin inside of Power BI.
Not totally sure if I need to do this inside Power Query or Outside PBI. Any help is highly appreciated!
v_mark
I am not familiar with using Google Map API. But the idea is to use Google Map API to get the lat and long of the addresses. Once you have the lat and long coordinates for each employe address, there are many posts and blogs about calcuating distance between locations.Solved: Distance Calculation in Power BI - Microsoft Power BI Community
Paul Zheng _ Community Support Team
1 Reply
v_mark
I am not familiar with using Google Map API. But the idea is to use Google Map API to get the lat and long of the addresses. Once you have the lat and long coordinates for each employe address, there are many posts and blogs about calcuating distance between locations.Solved: Distance Calculation in Power BI - Microsoft Power BI Community
Paul Zheng _ Community Support Team