In Progress Date from VSTS

[Anonymous]

Hi Guys,

First time posting here, trying to recreate some of the metrics we use in Excel for my Agile teams in Power BI, to then embed on our VSTS collection (example below):

The key fields I need are the In Progress date (or committed date) and the Closed date, as well as WIT and title of WIT.

Using the connector to desktop I can't see this data field...could anyone help me with how I can that info?

Thanks 🙂

[v-ljerr-msft · Accepted solution]

Hi @Anonymous,

Instead of using the build-in VSTS connector(Beta), could you try connecting to VSTS using the Power BI OData feed to see if you can get the key fields you need? Here is the article about how to connect to VSTS using the Power BI OData feed for your reference. 

Regards

[v-ljerr-msft · Accepted solution]

Hi @Anonymous,

Instead of using the build-in VSTS connector(Beta), could you try connecting to VSTS using the Power BI OData feed to see if you can get the key fields you need? Here is the article about how to connect to VSTS using the Power BI OData feed for your reference. 

Regards

[Anonymous · Accepted solution]

Perfect, that's given me what I was looking for!