Forum Discussion
PowerBI Getting Azure DevOps WorkItem History using OData
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.
2 Replies
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.
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
