Identifying Country from IP

[benjamin_sasin]

Hi, while building a report to analyse some of our application users, we're making guesses as to the country of the users (until they declare their nationality in their application form). I'm currently able to guess a country approximation from their phone number, and we are now also collecting the user's IP upon user creation, from which I would like to infer the country.

Is there any way I can do this from power query? If so how?

[v-juanli-msft · Accepted solution]

Hi @benjamin_sasin 

First you need to find IP address database or IP address file(online/local)

where you can lookup where the ip address is allocated from,

Second, connect to the IP address database or IP address file with Power BI Desktop, so we have a lookup table,

Third, match your ip adress column with the lookup table to find out where your ip address is allocated from.

You can find more details and code used in Power BI.

https://community.powerbi.com/t5/Desktop/IP-address-mapping/td-p/138436

As searched, you can find some IP address database or IP address file from the following links:

https://ipstack.com/

https://dev.maxmind.com/geoip/geoip2/geolite2/

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.