General Availability of Work Item Trend and Rollup Reporting in Power BI

Jeff Levinson

Today, a few short weeks after our initial release of the work item reporting capabilities in the Visual Studio Online Power BI Connector, we are happy to announce the general availability of trend and rollup reporting capabilities. Starting today you can do things like create sprint burndown charts based on story points, effort, size or remaining work.


These capabilities let you trend any data in the model over time.

The rollup capability allows you to provide summary counts of work items in different states under epics, features, or stories. With rollup counts you can get a count of estimated, completed, or remaining work,.

The following example shows a count of tasks by state for each of the user stories under their parent features.


With the release of these capabilities we have redone the out of the box report to provide a more complete view of your data including a new Open Bug Status report page with bug trends:


If you haven’t tried out the Power BI reporting features, give it a try now – it’s free! Instructions on getting started can be found here.

Please note that you will need to re-create your connection to Visual Studio Online in order to take advantage of the new model – models will not upgrade in place. Help documentation can be found here for these two new features:

Additional documentation will be released next week detailing the model and some anomalies people may experience because of the model design. As always, feedback is welcome – either on the new capabilities or on the new help documentation.


Jeff Levinson


Discussion is closed.

Feedback usabilla icon