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...
This is happening to me to. Auth works on desktop but fails in the service with "Your data source can't be refreshed because the credentials are invalid."
I am using Csv.Document(Web.Contents(url, [Headers=[Authorization="Bearer ...", #"Content-type"="application/x-www-form-urlencoded",#"Accept"="text/csv"]]))
Appears that power bi service is attempting to authenticate anonymously with the API url without sending the headers.