Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

API webservice don't work

Hi All, 

I've a question about to setup a webservice in Ppower BI desktop via New Query.

Via Postman i've got a connection and i get data, but when i setup this query in Power BI i get a result "no-data"

I guess there is something wrong with the notations:

Ik like to hear from you, regards Bart

 

Need Help

4 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    4 years ago

    One thing that looks off is that your content-type and accept are not part of the header record. Usually those are before the ] in your headers step.  Also, you may be able use Json.FromValue with your content as a record too (to more easily make the Json string.

     

    Pat

    • Bart's avatar
      Bart
      Frequent Visitor
      4 years ago

      Hi Pat, thank you but i'am quit new in setting up in webservice in power bi / query.

      do you maybe have an example of the structure of the get request with the information I send you last week?

       

      Thxs in advance, grt Bart

    • BartWitteveen's avatar
      BartWitteveen
      New Member
      4 years ago

      Hi Pat, 

      Sorry for the delay. 

      At this moment i've got the setup below

      I added the accept and content-type to the header, but i still get the result "Authentication error".

      You menioned to use the Json>FromValue. Can you give me with this example how i should add this to my Power Query script, i'am not familiar with this.

       

      PS: with Postman GET function i have a connection and get the desired data as result. So the Bearer Key is ok and working. 

       

      Thanks a lot in advance,

      Regards, Bart Witteveen