Adresse IP Url error

[Anonymous]

Hello all,

I want to get information from they adresse IP I had.

So I made this function.

let
    Source = (#"IP Address" as text) => let
        Source = Json.Document(Web.Contents("http://freegeoip.net/json/" & #"IP Address")),
        #"Converted to Table" = Record.ToTable(Source),
        #"Transposed Table" = Table.Transpose(#"Converted to Table"),
        #"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table")
    in
        #"Promoted Headers"
in
    Source

But I have this error.

Any one can explain for me why? Thank you.

Best,

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Please kindly try:

1) Go to the Power Query ribbon tab and click on Data Source Settings.

2) Click on the line with https://sharepointsite.com/... and delete the credential.

3) Refresh your query. When prompted, reenter your credentials.

[amitchandak]

@Anonymous , click on the error and share that.

refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs