Forum Discussion

yakkalipavan's avatar
yakkalipavan
Regular Visitor
8 years ago
Solved

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 Knew it is very common error and gone thorugh all the below links

 

https://community.powerbi.com/t5/Service/Anonymous-access/m-p/21014#M5916

 

http://community.powerbi.com/t5/Developer/Using-a-REST-API-as-a-data-source-Web-Contents-Content-option/m-p/115650#M4042

 

http://community.powerbi.com/t5/Service/Cannot-sign-in-with-Anonymous-Authentication-for-a-Web-API/td-p/168154?lightbox-message-images-168154=39597iD83266D92D25D020

 

 

the power Query is 

 

 

let 
AuthKey = "Basic  mytoken",
url="https://tfs.mnsu.edu/tfs/ITS%20AppDev/Test%20Agile%20Project/_apis/wit/wiql?api-version=1.0",
body="{
  ""query"": ""Select [System.Id], [System.Title], [System.State] From WorkItems Where [System.WorkItemType] = 'Task' and [System.AreaPath]='Test Agile Project'""
}",

Source = Json.Document(Web.Contents(url,[
         Headers = [#"Authorization"=AuthKey ,
                    #"Content-Type"="application/json"],
            Content = Text.ToBinary(body)
            ]
        ))
    
in
   Source

 

and error i am getting is 

 

can anyone please hemp

APIS and Embedding
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    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 

9 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    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 

    • devangddave's avatar
      devangddave
      Regular Visitor
      6 years ago

      Hi, I want to call the POST method of API using windows authentication in power bi.

      So I can't set it to Anonymous because API is hosted to use only Windows Authentication.

       

      Any suggestion, please

      • aegalan's avatar
        aegalan
        Frequent Visitor
        2 years ago

        Hello, did you solve your problem with the connection? i have the same issue.

  • davidalves's avatar
    davidalves
    Regular Visitor
    8 years ago

    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
   Source

    But 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's avatar
      Anonymous
      Not applicable
      7 years ago

      Pudiste solucionar esto? tengo el mismo problema, voy a subirlo en web y no puedo validar las credenciales....

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Como você resolveu esse problema? Estou passando por isso

  • yakkalipavan's avatar
    yakkalipavan
    Regular Visitor
    8 years ago

    Thanks for your help. Yes I followed your step and issue got resolved

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi davidalves,

     

    As your issue happens in Power BI service, while this thread talks about in Power BI desktop. I would suggest you post a new thread in this forum. 

     

    yakkalipavan As your issue is solved now, I will close this thread. Thanks for your update. 

     

    Best Regards,
    Qiuyun Yu