convert address to lat long

[ThomasDay]

I have a one time need to convert 1mm addresses to a lat/long after which the update process will only require maybe 10k updates per quarter.  All the plans seem to be geared to monthly volumes so hence my question...Anyone have any experience with this in their powerbi data transformations whether done in powerbi or pre-bi?

Thanks,

Tom

PS: It's probably worth saying I'm doing this to pre-compute the distance between data point pairs...and then find the "other" data points within a radius (set by a slicer) of any selected point.

[Greg_Deckler]

Generally, you use Bing Spatial Data Services:

• https://msdn.microsoft.com/en-us/library/ff701734.aspx
• https://msdn.microsoft.com/en-us/library/ff859477.aspx
• https://msdn.microsoft.com/en-us/library/gg585136.aspx

or Google Maps Geocoding API

• https://developers.google.com/maps/documentation/geocoding/usage-limits

[ThomasDay]

Thanks @Greg_Deckler.  It's a little byzantine to figure out the pricing.  We're non-standard in that we won't be attached to a map (powerbi can do that with an address) rather we're creating distances between points for slicers to go into a commercial application.  1MM geo codes can be expensive and hence the question.  

I was imagining I could use an opensourced service for the big push, then a bing like service for the quarterly changes...(which are modest).  Have you ever deciphered pricing for one time big jobs using bing?  I'd like to keep things in the "family" if possible.

Tom

[Greg_Deckler · Accepted solution]

You should email maplic@microsoft.com for assistance in determining the Bing Maps service and licensing program that’s best for your business.

https://azure.microsoft.com/en-us/marketplace/partners/bingmaps/mapapis/

[ThomasDay]

@Greg_Deckler  Thanks!  Should have marked this as the answer quicker.  As always, I'm in your debt---Tom