Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Solved! Go to Solution.
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
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
Thanks for your help. Yes I followed your step and issue got resolved
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
Pudiste solucionar esto? tengo el mismo problema, voy a subirlo en web y no puedo validar las credenciales....
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
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
Hello, did you solve your problem with the connection? i have the same issue.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |