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
Hi there

Did you test it manually via the URL?

If that works make sure that there are no spaces when passing it through via the function
indhu's avatar
indhu
Helper III
8 years ago

Worked. Thanks a lot :D

  • GilbertQ's avatar
    GilbertQ
    Super User
    8 years ago
    Awesome glad you got it working!
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Back again, Gilbert! So we opted to continue with the IP stack API. I seeimingly still cannot get the function work once I click close & apply. The code definitely works as it loads up the table I want once I have invoked the custom function. The issue I keep coming up against is a web access issue after. I am using the http version of the website not the https. Is there a way of running the function so I can avoid this? 

     

    This is my code below.

     

    = (#"IpAddress" as text) => let
    Source = Json.Document(Web.Contents("http://api.ipstack.com/"&#"IpAddress"&"?access_key=MYAPIKEY"& "&security=1")),
    #"Converted to Table" = Record.ToTable(Source),
    #"Transposed Table" = Table.Transpose(#"Converted to Table"),
    #"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table")
    in
    #"Promoted Headers"

     

    Thanks, 

    S

  • GilbertQ's avatar
    GilbertQ
    Super User
    7 years ago
    Hi there.

    I think you need to make it. Anonymous and put the API key as part of the url
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    How would I go about doing that? I'm only provided with two options. The website or the website + the IP address without the access key to follow.