IP Address Mapping in Power BI 07-23-2017 08:25 AM - last edited 01-25-2021 10:10 AM

[SamLester]

The following report and M code show how to perform an IP Lookup to obtain location details for a list of IP Addresses in order to map them in Power BI.

For detailed instructions, please see the blog here:

https://blogs.msdn.microsoft.com/samlester/2017/07/23/ipaddressmappinginpowerbi/

Thanks,
Sam Lester (MSFT)

eyJrIjoiM2MzZGE1YTktZTQxMS00ODE2LWIwNjAtNWQ1MmJhNDBmOTliIiwidCI6IjcyZjk4OGJmLTg2ZjEtNDFhZi05MWFiLTJkN2NkMDExZGI0NyIsImMiOjV9

[mwilner]

I am new to PowerBI and I have been trying to follow the instructions but found it didn't work for me as described.

I think in the GetAllFromIP the "Source = (FullURL) =>" should be Source = (FullIPURLCity) =>, right because that's how the column was named?

Then when trying to apply the query editor only the column FullIPURLCity is getting created but I don't get the table that should be coming from the GetAllFromIP function, I am missing a step I guess.

Trying to run just the function I get an error that the resulting format is HTML not JSON as expected, again, I think I am missing a step.

Any help, or ideas to fix this would be appreciated.

\Manfred

[mwilner]

One more quick update.

I finally found the sample PBIX file 😎

The CSV file noted in the sample is missing and referencing a local file! After creating a sample file I was able to load the project correctly and could analyze it. 

There were two steps in the project that are not described in the blog that were the missing pieces to my puzzle.

Also, when trying to execute the query I noted that the key keyword was missing, inserting this got me the expected result.

Unfortunately this only worked for my sample file with a few IP address samples but when I was trying to execute this against my large (over a thousand IP's) it errored out with an OLE DB or ODBC error: [DataSource.Error] Unable to connect to the remote server. 

I assume that there is a limit on how many IP's one can translate.