Get data from VSTS

[Anonymous]

VSTS Task Definition, i.e. EffortWhat data can I import from VSTS ?  We use EPIC, USE CASE, TASK, etc. very extensively in our Software Engineering, how can I find out what data i can import into Power BI Desktop?  For example when looking at a TASK in VSTS there are Effort values, Orignal Estimate, Remaining, and Completed.  Where can this information be found please?

[Jayendran]

Hi @Anonymous ,

Basically you can use Azure DevOps API to get the details for the work item

Reference:

https://docs.microsoft.com/en-us/rest/api/azure/devops/wit/work%20items/get%20work%20item?view=azure-devops-rest-5.1

http://www.codewrecks.com/blog/index.php/2019/08/19/sample-report-for-azure-devops/

[Anonymous]

Thank you very much,  i will read over this today and give it a go.  I'll update here once I look at this today.

Best Regards

CHS