Hi -
We have work item hierarchy in our project as Epic -> Feature -> User Story -> Bug.
lets say my Epic Id is 123, i am using below query to get all bugs for the epic. I am looking to create a PowerBI dashboard by creating a query as below but the response is giving incorrect data. Kindly advise.
let
Source = OData.Feed("https://analytics.dev.azure.com/{workspace}/{project}/_odata/v3.0-preview/WorkItems?" & "$filter=WorkItemId ge 123" & "and State ne 'Closed' and State ne 'Removed'" & "&$select=Title,WorkItemType,State,AreaSK" & "&$expand=AssignedTo($select=UserName),Iteration($select=IterationPath),Area($select=AreaPath)," & "Links(" & "$filter=LinkTypeName eq 'Child'" & "and TargetWorkItem/WorkItemType eq 'Bug';" & "$select=LinkTypeName;" & "$expand=TargetWorkItem($select=WorkItemType,WorkItemId,Title,State)" & ")", null, [Implementation="2.0", OmitValues=ODataOmitValues.Nulls, ODataVersion=4]),
#"Filtered Rows" = Table.SelectRows(Source, each ([WorkItemType] = "Bug"))
in
#"Filtered Rows"
