Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

In Progress Date from VSTS

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 :)

 

 

  • 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. :smileyhappy:

     

    Select the entities of data to retrieve

     

    Regards

  • Anonymous's avatar
    Anonymous
    8 years ago

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

2 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee

    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. :smileyhappy:

     

    Select the entities of data to retrieve

     

    Regards

    • Anonymous's avatar
      Anonymous
      Not applicable

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