Reporting UI or PowerBI Connectivity

Officially Answered

Comments

8 comments

  • Avatar
    dev

    The advantage of your app is that it is kept against tasks. 
    I would like original estimate vs time spent per person 
    Please bring to power BI

  • Avatar
    Marc Schaeffler

    Some insights out of development on TFS Timetracker for VSTS: The worklogs are stored in additional databases that are outside the API from VSTS. Currently, data can only be exported and processed manually. We are working on the API for VSTS, as well as Power BI integration as well as on build in reporting. Any comments and special requirements are welcome.

  • Avatar
    dev

    Hello,

    I would also like to know how are the logged hours persistented. Can you get the data over the the Visual Studio Online Rest Endpoint, so you can make your own Reports based on the Tracked Hours and Estimated Hours etc.?

    Greetings 
    Kai

  • Avatar
    Belindata

    Hi Marc,

    Any progress with PowerBI integration?

    Thanks,

    B

  • Avatar
    Maxim

    It is possible to get data from Timetracker API using Power BI standalone. Please see this article explaining how to connect with Excel. It is the same procedure for Power BI: (edited) https://support.7pace.com/hc/en-us/articles/115002713186--API-for-7pace-Timetracker-for-TFS

  • Avatar
    Mark Powell

    This link above is broken - can you provide an updated URL for Excel/Power BI connectivity article?

  • Avatar
    Maxim

    Hi Mark, sorry for broken link, here it is valid one: https://support.7pace.com/hc/en-us/articles/115002713186--API-for-7pace-Timetracker-for-TFS

    Maxim

  • Avatar
    Mark Powell

    Thank you

Please sign in to leave a comment.

Powered by Zendesk