Forum Discussion
mass ip geolocation
Hey PowerBI,
I'd like to conduct a mass look up of all IP addresses within my file providing them with associated latitudes and longitudes so I can accurately locate where they map out to. I have around 3900 distinct Ip addresses altogether. I then need to hook this up to my masterfile which contains various details about users etc.
Ideally I'd like to use the maxmind API to get "Country", "City", "longitude", "latitude" and "is_proxy" data. I know of a previous solution posted by GilbertQ however since then, that site has since been deprecated. The data from that also doesn't suit my own purposes.
I know this is doable, but just lack the knowledge in M to do this!
https://www.maxmind.com/en/geoip2-precision-services
Many thanks
22 Replies
Hi Anonymous,
It would be better you could provide sample data and show us your desired result.
How to Get Your Question Answered Quickly
Regards,
Yuliana Gu
- Hi there
I have a blog post coming out later today (Australian time) where I explain how to use a different IP Address Lookup with a way to limit how quickly it will query the API.
You can find it here: https://www.fourmoo.com/blog- Please let me know if it works.
Looking forward to that virtual glass of champagne
Hi GilbertQ,
Thanks for the wonderful post. The problem I am facing when trying to implement is, access restriction when trying to use freegioip.net. When I further researched I found that their address has been changed to ipstack.com
How should we design for this particular website? they changed the plan and not sure how to do that.
Thanks,
Indhu
