topic Re: Get data from VSTS in Developer

Get data from VSTS

Anonymous — Wed, 28 Aug 2019 18:59:31 GMT

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?

Re: Get data from VSTS

Jayendran — Thu, 29 Aug 2019 10:24:41 GMT

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/

Re: Get data from VSTS

Anonymous — Thu, 29 Aug 2019 13:48:20 GMT

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