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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Kudoed Authors