workitem parent parent

[jonathan-levy]

Hi

I'm trying to get the grand parent of a work item in VSTS. So I want to get the epic work item from a user story but it's giving me this error:

The query specified in the URI is not valid. The Analytics Service doesn't support key or property navigation like WorkItems(Id) or WorkItem(Id)/AssignedTo. If you getting that error in PowerBI, please, rewrite your query to avoid incorrect folding that causes N+1 problem

Any idea how I can solve it? I've seen the comments here (https://docs.microsoft.com/en-us/vsts/report/extend-analytics/odata-query-guidelines) but I can't make sense of it.

Thanks

[v-yuezhe-msft]

@jonathan-levy,

Which URL do you put in the ODATA entry of Power BI Desktop? As stated in the article you mentioned, it is recommended that you use explicit entity addressing. There is an example below.

https://{account}.analytics.visualstudio.com/_odata/v1.0/WorkItems?
  $filter=WorkItemId eq {id}
  &$select=WorkItemId, Title

Regards,
Lydia