cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
v_mark
Helper III
Helper III

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! 

 

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

@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

View solution in original post

1 REPLY 1
V-pazhen-msft
Community Support
Community Support

@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

View solution in original post

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors