Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Issue when scheduling refresh using postman rest api public key

Hi,   I just loaded a data in power bi dsktop using postman rest api as below in blank query  actualUrl = "http://*******************?", options = [Headers =[#"Content-type"="application/json", #...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Eventhough it is not working. Data can be pulled in desktop and still in service can't able to refresh. It's showing refresh error as failed to update data source crendentials. since it's public key doesn't have credentials

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Anonymous ,

 

Would you please try to chang your anonymous to "basic" connection on power bi desktop and passed the API key as the username (left password blank).

But make sure you get rid of API key in your advanced editor if you did set one.

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi 

     

    • ibarrau's avatar
      ibarrau
      Super User
      5 years ago

      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
Source

       That is an example with body and headers. Try adding your public key there like in postman.

      Regards,

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thanks Dedmon, that has worked wonders for me. Thanks.