PowerMap/BI can directly map IP Addresses (IP lookup then render)

[danpl]

Scenario: I have a survey result set from a popular survey site. It has hundreds of rows of data with IP addresses. I want to map them. Gap: PowerMap can't directly take IP addresses and map them Ask: How PowerMap call a backend service run by Microsoft that can transform IP address data into useful inputs to PowerMap.

[fbcideas_migusr]

One way of solving this is by using a 3rd party IP-Location API and connect to it from Power Query. You can invoke that service over a table with IPs and get back the Lat/Long information.

[Gordon_Byers]

Agree that this should be taken care of before Power Bi sees the data, however Power Bi seems to have a problem with aggregating the longitude and latitude for the map making it unusable.

[FortnerJonathan]

Interesting. I can see a few uses for being able to Map IP addresses to their locations. For example, where are people from that are hitting my web site or logging into my server? The difficulty is that many IP addresses are masked by the user's internet provider or company firewall/routers. But even those might be helpful to see visually.

[GEORGEW2]

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