Forum Discussion
Issue when scheduling refresh using postman rest api public key
Hi Anonymous ,
Would you please try to select the "skip test connection" option? For more details, please refer to https://kohera.be/blog/power-bi/the-hidden-gems-of-the-function-web-contents/
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi v-deddai1-msft,
I tried that, even though it's not working. Actual problem is I am fetching data from postman using public key as header. In Power bi, using web web connector It's working. while refreashing it's asking for update credentials. My question, for public key why I want credentials?. Kindly help me with this..
Regrads,
Krithika
Ok let's add the key as headers. Check this example: if your URL is this one "https://swapi.dev/api/people/?search=Skywalker" you can build this:
let
Json_body = Json.FromValue("{ ""first_param"": ""AAAAA"", ""second_param"": ""BBBBBB""}",),
Source = Json.Document(Web.Contents("https://swapi.dev/api/", [
RelativePath="people/",
Query=[search="Skywalker"],
Headers=[
#"Content-Type"="application/json",
Otherparameter"ValueOfParameter"
],
Content=Json_body
]))
in
SourceThat is an example with body and headers. Try adding your public key there like in postman.
Regards,