Find a Custom Work Item Field
Azure DevOps work item templates offer the flexibility to customize by adding new fields, allowing teams to tailor the platform to their specific software processes. These newly added fields will automatically appear in the Analytics Views list. However, if your data source is ODATA, you will need to locate this field using a metadata query to correctly use the field in the ODATA query. This blog shows you how to find a custom work item field added to the ADO work item template and use in the ODATA query.
For example, the Team Triage field is added to the Bug work item template.
The new field is available through the Analytics Views fields editor. Using Analytics Views is by far the easiest method to get started with reporting on work items. Review this blog on getting started with Power BI reporting on ADO data to see a list of blogs on using Analytics Views.
How to Find the Field in the ODATA Metadata
In VS Code, run the following ODATA query. Change out the Your-ADO-Org and Your-Team-Project with your ADO information.
If you are unfamiliar with running ODATA queries in VS Code, then check out this blog post on getting started.
https://analytics.dev.azure.com/Your-ADO-Org/Your-Team-Project/_odata/v4.0-preview/$metadataearch for the custom field added to the work item template.
The Property Name field is used in the ODATA query. For this field, it is Microsoft_DevDiv_TeamTriage.
Open Power Query editor in Power BI and update your ODATA query with the field name.
Refresh the data in Power BI.
Rename the column.
Select Close and Apply to use the field in the report.
Hope this helps with your reporting journey with ADO analytics!