Get Started
Support Home

We’ve launched a new Help Center!

Visit the new Documentation space for Azure DevOps, monday.com, and Jira. Or, if you require any assistance or have any questions, please visit the new Customer Support Portal for Azure DevOps, monday.com and Jira.

Learn more

Reporting UI or PowerBI Connectivity

Implemented
Follow
New post
Avatar
dev

I'd like some way to easily report on the hours spent by project per time period (day, week, month, custom range) as well as by person. I'd imagine these to be separate charts. I'm not sure if extensions are allowed to be exposed to PowerBI connectivity, with the other VSTS data, but that would also be a viable solution, then customers can create reports for all different types of data.

0

Comments

8 comments

Sort by Date Votes
  • 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

    0
    Comment actions Permalink
  • 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.

    0
    Comment actions Permalink
  • 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

    0
    Comment actions Permalink
  • Avatar
    Belindata

    Hi Marc,

    Any progress with PowerBI integration?

    Thanks,

    B

    0
    Comment actions Permalink
  • Avatar
    Permanently deleted user
    • Edited

    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

    0
    Comment actions Permalink
  • Avatar
    Mark Powell

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

    0
    Comment actions Permalink
  • Avatar
    Permanently deleted user

    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

    0
    Comment actions Permalink
  • Avatar
    Mark Powell

    Thank you

    0
    Comment actions Permalink

Post is closed for comments.

Powered by Zendesk