cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MoeAnalytics
Microsoft
Microsoft

The query specified in the URI is not valid - querying ADO via OData Feed

I'm connecting to ADO via an Odata connection.  When I try to expand one of the columns to extract a field, I get the below error.

Screenshot 2021-04-09 110224.png

This is my query:

let
Source = OData.Feed("https://analytics.dev.azure.com/MyOrganization/My%20Project/_odata/v3.0-preview/WorkItems?", null, [Implementation="2.0"]),
#"Expanded StateChangeOn" = Table.ExpandRecordColumn(Source, "StateChangeOn", {"Date"}, {"StateChangeOn.Date"})
in
#"Expanded StateChangeOn"

 

It doesn't matter which field I try to expand, I get the same error on any column. Any help is appreciated.

1 REPLY 1
v-kelly-msft
Community Support
Community Support

Hi @MoeAnalytics ,

 

Seem that your query violates an OData error rule,check the reference below:

https://docs.microsoft.com/en-us/azure/devops/report/extend-analytics/odata-query-guidelines?view=az...

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors