Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
{on-premise-server-name}/{company-name)/{project-name}/_backlogs/backlog/DOIT-II%20Team/Features
Hello.
I am interested in the data for "Incident"
I connected using Power BI OData feed specifying:
Source = OData.Feed("{on-premise-server-name}/{company-name)/{project-name}/_odata/v2.0/", null, [Implementation="2.0",OmitValues = ODataOmitValues.Nulls,ODataVersion = 4])
Yet I get general data in WorkItems table. I don't get the data inside Incident
Any idey where/how can I retrieve this data?
Thank you.
Solved! Go to Solution.
Hi @Anonymous
You could try the workaround in this link Is there a way to pickup backlog item data from the Azure DevOps API? - Stack Overflow.
The corresponding REST APIs for Azure DepOps Server are Backlogs - Get Backlog Level Work Items and Work Items - Get Work Items Batch
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @Anonymous
You could try the workaround in this link Is there a way to pickup backlog item data from the Azure DevOps API? - Stack Overflow.
The corresponding REST APIs for Azure DepOps Server are Backlogs - Get Backlog Level Work Items and Work Items - Get Work Items Batch
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Thank you @v-jingzhang .
I followed a similar approach.
I got the work items' id and then using Rest API I retrieved the data I wanted.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 5 | |
| 5 | |
| 4 |