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...
Need Help
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

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