Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Adresse IP Url error

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,

Interesting Links
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    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.

     

     

2 Replies