Forum Discussion
convert address to lat long
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.
You should email [email protected] 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/
4 Replies
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
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
You should email [email protected] 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/
