TFS 2017 | TFS 2015 | TFS 2013
Excel reports, Reporting Services reports, and SharePoint dashboards are only supported for on-premises TFS. For information on what is supported for VSTS, see Dashboards, charts, & widgets.
TFS 2018 and later versions no longer support native integration with SharePoint products. If you're planning to upgrade to TFS 2018, read About SharePoint integration to learn about the options available to you.
If you see that hours are counted twice in reports that contain task hours, you can correct the problem with the procedure in this topic. The Progress dashboard and the Burndown and Burn Rate and Remaining Work reports may show double-counting of work hours.
When you use Office Project to create parent and child tasks, it assigns parent tasks the rollup of hours that are defined for all its child tasks. Rollup hours are not published to Team Foundation so that the hours are not double-counted in certain reports. The Microsoft Project mapping file attribute, IfSummaryRefreshOnly, suppresses the publication to Team Foundation of the hours that are assigned to summary tasks. You can view the rollup of hours for summary tasks in Office Project but not in Team Foundation. For more information, see Customize the Microsoft Project field mapping file.
When both summary tasks and their child tasks contain hours in the effort fields, you essentially have double-counting of the level of task effort. To address these inaccuracies, you must clear the Original Estimate (or Baseline Work for team projects that have been upgraded), Remaining Work, and Completed Work fields for the summary or parent tasks.
To perform this procedure, you must be a member of the Contributors group or your View work items in this node and Edit work items in this node permissions must be set to Allow. For more information, see Permission reference.
To clear the hour fields of parent or summary tasks
In Team Explorer, expand the Work Items node for your team project, and locate the Work Items with Summary Values team query.
This query is located either in the Team Queries folder or the Planning and Tracking folder under the Team Queries folder.
Run the query.
Select (Collapse All) so that only parent or summary work items appear in the query results.
Press CTRL+A to highlight the parent work items that are listed.
Open the context menu for one of the work items, and then choose Open in Microsoft Excel.
Export the query results to Office Excel with the rows collapsed. This condition exports only the parent or summary tasks.
In the Excel document, for the area and iteration paths that you are managing, clear the values in the following three columns:
(Optional) Save the Excel file.
The work items in this list are based on the work item IDs and not a work item query. To address inaccuracies that may occur later, you must repeat steps 1 through 6.
On the Team tab, choose Publish.
Wait two or more hours for the Analysis Services cube to register the changes.
The default refresh frequency for the relational data warehouse is two minutes, and for the cube, two hours. For more information, see Change a process control setting for the data warehouse or Analysis Services cube.
Verify that the changes have been picked up by viewing the Progress dashboard or other work report.