{"id":9631,"date":"2015-07-22T08:07:11","date_gmt":"2015-07-22T08:07:11","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/visualstudioalm\/2015\/07\/22\/reporting-on-work-items-with-power-bi\/"},"modified":"2022-08-01T07:03:15","modified_gmt":"2022-08-01T15:03:15","slug":"reporting-on-work-items-with-power-bi","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/devops\/reporting-on-work-items-with-power-bi\/","title":{"rendered":"Reporting on Work Items with Power BI"},"content":{"rendered":"<p>Ever since the initial release of reporting with Power BI against Git and Team Foundation Version Control, the single consistent question was \u201c<strong>When will I get the ability to report on work items?<\/strong>\u201d<\/p>\n<p><strong>The answer is \u201cToday\u201d.<\/strong> Shown below is a partial view of the new updated dashboard.<\/p>\n<p><img decoding=\"async\" title=\"image\" style=\"border-left-width: 0px;border-right-width: 0px;border-bottom-width: 0px;padding-top: 0px;padding-left: 0px;padding-right: 0px;border-top-width: 0px\" border=\"0\" alt=\"image\" src=\"https:\/\/devblogs.microsoft.com\/devops\/wp-content\/uploads\/sites\/6\/2015\/07\/5556.image_thumb_5803FA6E.png\" width=\"705\" height=\"433\" \/><\/p>\n<p>The first question that I\u2019ve been asked is <strong>\u201cWhat\u2019s included?\u201d<\/strong> So let me share some of our plans around what we\u2019ve delivered and what we\u2019re hard at work on.<\/p>\n<p>In this release, we support the current state of work items only. That means you can\u2019t do a burndown yet and you can\u2019t do rollup yet.<\/p>\n<p><strong>What can you do with this first release of work item reporting?<\/strong><\/p>\n<ul>\n<li>Report across team projects <\/li>\n<li>Velocity charts <\/li>\n<li>Filtering by area, iteration, tags and any other fields <\/li>\n<li>Add some advanced metrics such as median days in state and 95th percentile days in state \u2013 we\u2019ll be adding more of these as we go <\/li>\n<\/ul>\n<p>The next question is always <strong>\u201cWhat are we enabling next?\u201d<\/strong> We\u2019re currently hard at work on the history and rollup capabilities and will be releasing these next (concurrently). These should be available by the end of August. After that comes Kanban data.<\/p>\n<p>The next question we invariably get is **\u201cWhen will this be available for on-premises use?\u201d **<\/p>\n<p>However, the answer to this is still TBD because Power BI does not support our on-premises installation as of today. We are still working on our plans in this area.<\/p>\n<h2>How to use the new model<\/h2>\n<p>The structure of the work item dimensions are shown here (this is representative \u2013 there are other dimensions such as Issue and Risk which aren\u2019t shown here):<\/p>\n<p><img decoding=\"async\" title=\"image\" style=\"border-left-width: 0px;border-right-width: 0px;border-bottom-width: 0px;padding-top: 0px;padding-left: 0px;padding-right: 0px;border-top-width: 0px\" border=\"0\" alt=\"image\" src=\"https:\/\/devblogs.microsoft.com\/devops\/wp-content\/uploads\/sites\/6\/2015\/07\/0741.image_thumb_2CBF6367.png\" width=\"565\" height=\"352\" \/><\/p>\n<p>This model provides core work items dimension and then related dimensions for each of the individual work item types. The core work items table contains the System.* fields and some measures such as Work Items (which is the count of work items). The individual work item dimensions contain fields that are specific to those work items. For example, you\u2019ll find the Remaining and Completed Work measures in the Task and Bug dimensions.<\/p>\n<p>Each work item dimension also has its own count. For example, in the Bugs dimension there is a Bugs measure which is the count of bugs. To get the count of bugs for an iteration you could do either of the following:<\/p>\n<ol>\n<li>Drag iteration onto the report page <\/li>\n<li>Click the Bug measure in the bugs table <\/li>\n<\/ol>\n<p>OR<\/p>\n<ol>\n<li>Drag iteration onto the report page <\/li>\n<li>Click the Work Items measure in the Work Items dimension <\/li>\n<li>Filter the Work Item type by bug <\/li>\n<\/ol>\n<p>Either will work equally well. A major reason for using the work item table is to get breakdowns by work item type or assigned to across work item types.<\/p>\n<p>Providing dimensions by work item type yield measures which relate specifically to that dimension. Take the Issues dimension. Issues, by default have a due date field. There are two numeric values that we support \u2013 Days Past Due and Days Until Due which calculate off of this date.<\/p>\n<p><strong>Will this model change going forward?<\/strong><\/p>\n<p>Yes. The data model for work items will change in future releases because of certain technical requirements we have however, the basic structure will remain the same.<\/p>\n<h2>Getting Started<\/h2>\n<p>To get started, head over to <a href=\"https:\/\/msit.powerbi.com\/groups\/me\/getdata\/services\/visual-studio-online\" title=\"https:\/\/msit.powerbi.com\/groups\/me\/getdata\/services\/visual-studio-online\">https:\/\/msit.powerbi.com\/groups\/me\/getdata\/services\/visual-studio-online<\/a> and start pulling data! Sign up for a free account if you don\u2019t have one. Documentation on getting started can be found <a href=\"https:\/\/www.visualstudio.com\/get-started\/report\/report-on-vso-with-power-bi-vs\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p>Please provide any feedback in the comments here or on <a href=\"http:\/\/visualstudio.uservoice.com\/forums\/121579-visual-studio\/category\/30925-team-foundation-server-visual-studio-online\" title=\"http:\/\/visualstudio.uservoice.com\/forums\/121579-visual-studio\/category\/30925-team-foundation-server-visual-studio-online\">http:\/\/visualstudio.uservoice.com\/forums\/121579-visual-studio\/category\/30925-team-foundation-server-visual-studio-online<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ever since the initial release of reporting with Power BI against Git and Team Foundation Version Control, the single consistent question was \u201cWhen will I get the ability to report on work items?\u201d The answer is \u201cToday\u201d. Shown below is a partial view of the new updated dashboard. The first question that I\u2019ve been asked [&hellip;]<\/p>\n","protected":false},"author":170,"featured_media":45953,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-9631","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-devops"],"acf":[],"blog_post_summary":"<p>Ever since the initial release of reporting with Power BI against Git and Team Foundation Version Control, the single consistent question was \u201cWhen will I get the ability to report on work items?\u201d The answer is \u201cToday\u201d. Shown below is a partial view of the new updated dashboard. The first question that I\u2019ve been asked [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/9631","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/users\/170"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/comments?post=9631"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/9631\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media\/45953"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media?parent=9631"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/categories?post=9631"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/tags?post=9631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}