Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

mass ip geolocation

Hey PowerBI,    I'd like to conduct a mass look up of all IP addresses within my file providing them with associated latitudes and longitudes so I can accurately locate where they map out to.  I ha...
Need Help
GilbertQ's avatar
GilbertQ
Super User
8 years ago
Please let me know if it works.

Looking forward to that virtual glass of champagne
Anonymous's avatar
Anonymous
Not applicable
8 years ago

= Table.AddColumn(#”Changed Type”, “fn_GetIPAddressDetails”, each Function.InvokeAfter(()=>fn_GetIPAddressDetails([IpAddress]), #duration(0,0,0,#”Interval (Secs)”))) 

 

So i paste in the above code as your step says over the Invoked function column. But I get the error "Invalid Literal" 

  • GilbertQ's avatar
    GilbertQ
    Super User
    8 years ago

    Hi there,

    If you can change the double quotes to be ", as due to the copy and paste they are the italic double quotes

     

    = Table.AddColumn(#"Changed Type1", "ParkRun", each Function.InvokeAfter(()=>fx_ParkRunData([Run]), #duration(0,0,0,#"Refresh Interval")))
    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hey GilbertQ, No worries I got it working. Takes a pretty long time but thats expected I have 4.3k Ip Addresses. Not sure if my issue is with the API service or not now because there is a limit. But I will come up with an issue that says "access to the resource is forbidden" with the url of the website "http://api.ipstack.com/[IpAddress]". This is the same issue I faced previously when using the API and seems the InvokeAfter.Function won't do the job.... 

       

      Any other ideas? 

      • GilbertQ's avatar
        GilbertQ
        Super User
        8 years ago
        Hi there

        I think it might then be a limit on the site in terms of how many free IP Addresses you can geocode?