PowerBI Getting Azure DevOps WorkItem History using OData

[prabhatnath]

Hi Friends,

Currently, I am getting Azure DevOps Work Items into my Power BI using the following OData query and it is giving me the work items and details that are needed. But this does not give the History of the Work Item changes. 

https://analytics.dev.azure.com/{OrgName}/{ProjectName}/_odata/v3.0-preview/WorkItems

Is there an OData Query that will get the Work Item History as well for us? Please suggest.

Thanks,

Prabhat 

@PhilipTreacy  I see some of your replies related to Azure DevOps so adding you as well. 

[Anonymous]

Hi @prabhatnath 

1.You can ues the visual studio and odata together to get the history record, you cam refer to the following link.

Connect with data by using OData queries - Azure DevOps | Microsoft Learn

2.You can use Azure Devops connector directly in power bi Desktop, you can refer to the following link.

azure - How do I Track Work item history using Power BI? - Stack Overflow

Create a Power BI report with an Analytics view - Azure DevOps | Microsoft Learn

Best Regards!

Yolo Zhu

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

[prabhatnath]

Thanks for the links. As my primary data are pulled using OData query I was looking for the query to get history data using OData instead of Analytics View. Not sure how that is achievable?

Thanks,

Prabhat