Dan Plastina on 03 Mar 2015 07:53:48
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.
- Comments (4)
RE: PowerMap/BI can directly map IP Addresses (IP lookup then render)
Does this help? https://community.powerbi.com/t5/Desktop/IP-address-mapping/td-p/138436
RE: PowerMap/BI can directly map IP Addresses (IP lookup then render)
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.
RE: PowerMap/BI can directly map IP Addresses (IP lookup then render)
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.
RE: PowerMap/BI can directly map IP Addresses (IP lookup then render)
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.