cant authenticate odata feed VSTS

Question

i cant seem to get this query ti authenticate.

let

Source = OData.Feed("

https://analytics.dev.azure.com/***/_odata/v3.0-preview/WorkItems?" & "&$select=WorkItemId", null, [Implementation="2.0"]),

#"Retrieve VSTS DATA" = Table.AddColumn(Source, "VSTS", each Json.Document(VSTS.Contents("

https://dev.azure.com/***/_apis/wit/workitems/"

&Number.ToText([WorkItemId]))))

in

#"Retrieve VSTS DATA"

anonymous · Answer

Hi&nbsp;Robert14358&nbsp;，Per my test, I can connect to my own azure devops with the code you shared:

If so, make sure you are using the correct organization name and project name in your query.Also make sure you are a member of the project with basic access or higher rights.You could also ask the project administartors to run the query to check the result.More information for your reference:Connect with data by using OData queries - Azure DevOps | Microsoft LearnAdd users to organizations and manage access - Azure DevOps | Microsoft Learn
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

robert14358 · Answer

are u able to do this in a dataflow?

anonymous · Answer

Hi&nbsp;Robert14358&nbsp;,Yes, we suggest you use a simple path to connect first, then paste the full query in Advanced Editor:https://analytics.dev.azure.com/***/_odata/v3.0-preview/WorkItems?$select=WorkItemId
&nbsp;

&nbsp;

Best regards,
Joyce
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.
&nbsp;