Forum Discussion

WorkWithCode's avatar
WorkWithCode
Frequent Visitor
6 years ago
Solved

Web-api stops my dataset from refresing

Hi all,   I have a problem with my dataset. I'm using a function in powerquery that pinpoints the exact location of someone's adress. But when I try to refresh the dataset I get this message: There...
Need Help
Show and Tell
Tutorial Requests
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi WorkWithCode ,

     

    Sorry for that it seems my previous formula is incorrect, please change the first step as following:

     

    Bron = Web.Contents("http://API_URL", [RelativePath="hello", Query=[q="SearchTerm"&location,o="xml",key="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"]]),

     

    the value of Query option should be adjusted by your api, such as the location, we think it may be a url paramater, but if you want to q=SearchTermlocation, it may changed to following:

     

    Bron = Web.Contents("http://API_URL", [RelativePath="hello", Query=[q="SearchTermlocation",o="xml",key="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"]]),


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi WorkWithCode ,

 

Apologize, I am sure it is because my mistake, when I change the query, I forgot to add the Xml.Tables() Back after modify.

 

Bron = Xml.Tables(Web.Contens( Change to the query which works on your side...) )


Best regards,

 

WorkWithCode's avatar
WorkWithCode
Frequent Visitor
6 years ago

hi v-lid-msft,

 

Thanks for the help I get only 1 last error message

Expression.Error: Access to the resource is prohibited.

 I thinks it's the api key but i'm not sure. I link the video where i have found this function here: https://www.youtube.com/watch?v=YxwU5UubWjI

 

thanks for the help.