Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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://dev.maxmind.com/geoip/geoip2/geolite2/
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://dev.maxmind.com/geoip/geoip2/geolite2/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.