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

[MoeAnalytics]

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.

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.

[v-kelly-msft]

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!