Forum Discussion

Resolver I

6 years ago

Solved

Identifying Country from IP

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 current...

Need Help

v-juanli-msft
6 years ago
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.