Get Azure DevOps workitem links across projects

[deepak_mhaskar]

Hi Folks,

I am pulling the workitem data from Azure DevOps from a specific project.

That projects has some workitem links which has workitem links outside the projects (workitem link from other project in same organization)

I tried to use below Odata query, however it seems it only pulls links from current project:

let
    Source = OData.Feed("https://analytics.dev.azure.com/liox-teams/Production%20Incidents/_odata/v3.0-preview/WorkItems?$select=WorkItemId,Title,WorkItemType,State&$expand=Links($select=SourceWorkItemId,TargetWorkItemId,LinkTypeName;$expand=TargetWorkItem($select=WorkItemId,Title,State))", null, [Implementation="2.0"]),
    #"Expanded Links" = Table.ExpandTableColumn(Source, "Links", {"SourceWorkItemId", "TargetWorkItemId", "LinkTypeName", "TargetWorkItem"}, {"Links.SourceWorkItemId", "Links.TargetWorkItemId", "Links.LinkTypeName", "Links.TargetWorkItem"}),
    #"Expanded Links.TargetWorkItem" = Table.ExpandRecordColumn(#"Expanded Links", "Links.TargetWorkItem", {"WorkItemId", "Title", "State"}, {"Links.TargetWorkItem.WorkItemId", "Links.TargetWorkItem.Title", "Links.TargetWorkItem.State"}),
    #"Filtered Rows" = Table.SelectRows(#"Expanded Links.TargetWorkItem", each true)
    
in
    #"Filtered Rows"

Can you help with getting links outside the current project?

Any suggesttions / comments - Most welcome!

Regards,

Deepak

[erjosito]

I have the same question. Essentially, the remoted links are not part of the 'Links' table. Inspecting the ADO data with PowerShell it looks like the remote links are in a `url` field, but I can't access that field with the OData queries that are provided in the documentation above 😞

[v-eqin-msft]

Hi @deepak_mhaskar ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @deepak_mhaskar ,

As the official document said, The Analytics service and Power BI reports support creation of reports that span two or more projects. 

Please refer to:

Create a Power BI report with an OData Query - Azure DevOps | Microsoft Docs

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