Forum Discussion
yakkalipavan
8 years agoRegular Visitor
Web.Contents with the Content option is only supported when connecting anonymously.
Hello All, I am connecting to api using basic token. but I am getting the authentication issue which is "Web.Contents with the Content option is only supported when connecting anonymously." i...
- 8 years ago
Hi yakkalipavan,
From your description, you already provide the access key in Power Query, but you didn't choose Anonymous authentication for the web data source, so the error throws out.
Please open Data Source Settings, then find the web data source, choose Anonymous like below:
Update: Please mask the actual data source domain name in the screenshot.
Best Regards,
Qiuyun Yu
davidalves
8 years agoRegular Visitor
Hi @yakkalipavan,
Have you resolved this?
It's working for me with Anonymous authentication in Desktop.
let
Source = (Collection as text, QueryID as text) => let
AuthKey = "Basic APIKEY(camouflaged-> i use Postman)",
url="https://tfs.primaverabss.com/tfs",
Source = Json.Document(Web.Contents(url,[
Headers = [#"Authorization"= AuthKey ,
#"Content-Type"= "application/json"],
RelativePath= Collection & "/_apis/wit/wiql/"& QueryID &"?api-version=1.0"
]
))
in
Source
in
SourceBut when i publish this in web i can't use any credentials because this error:
Can anyone help me?
Best Regards,
David Miguel Alves
Anonymous
1 year agoNot applicable
Como vocĂȘ resolveu esse problema? Estou passando por isso