cant authenticate odata feed VSTS

[Robert14358]

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"

[Robert14358]

i am the only one who does this for my company

[Anonymous]

Hi @Robert14358 ,

Thank you for the confirmation.

However, the issue is more related to user credential, we still suggest you switch to different accounts to compare the results.

[Robert14358]

it does not allow to not have a gateway in dataflows.

[Anonymous]

@Robert14358 ,
Please help confirm if other organizational users are experiencing the same issue.

[Robert14358]

this is the step that doesnt work

[Anonymous]

@Robert14358 ,
Is the gateway you selected online?
Can you please select No Gateway and log in again to compare results?

[Robert14358]

are u able to do this in a dataflow?

[Anonymous]

Hi @Robert14358 ,
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

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Robert14358 ，
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 Learn
Add 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.