Hi Team, I have created a web api which validates the http header and gives the response in Json format. I have added this api as a data source for a report in power bi desktop which is working f...
danilm
8 years agoRegular Visitor
Hi @SowjanyaK,
I moved the authentication token inside the query string, as you suggested.
Changed
Json.Document(Web.Contents("...", [ApiKeyName="Api-Token"))
to
Json.Document(Web.Contents("...&Api-Token=xxxxxxxxxx"))
Same problem. Works in PowerBI Desktop, but fails in cloud (Authentication Method: Anonymous):
Failed to update data source credentials: The credentials provided for the Web source are invalid.
Can you confirm this is a known issue, or am I doing something wrong?
Thank you,
Danil