Analytics View with Power BI

• Here is the URL for you to create your own Analytics Views.

http://<YourServerName>/<YourCollectionName>/<YourProjectName>/_analytics

 

• There are some out-of-box view you can start using as well.

 

• You’ll need permissions to create, edit, and delete those views.

• To download Power BI desktop, go to https://powerbi.microsoft.com/en-us/downloads/

 

• To get data from those views, please select “Azure DevOps Server (Beta)” from “Online Service”

 

• Then provide the collection URL and Team Project name

 

• Then Select view(s) to load

 

• After that, you can start drag and drop and slice and dice your data.

 

• You can also leverage oData query to create your own data set. There are some documents and samples: https://docs.microsoft.com/en-us/azure/devops/report/powerbi/overview?view=azure-devops

 

• For example, for an Open Bugs report, you can use the following query

let

   Source = OData.Feed (“http://<YourServerName>/<YourCollectionName>/<YourProjectName>/_odata/v1.0/WorkItems?&#8221;

        &”$filter=WorkItemType eq ‘Bug’ “

            &”and StateCategory ne ‘Completed’ “

            &”and startswith(Area/AreaPath,'<YourAreaPath>’) “

        &”&$select=WorkItemId,Title,WorkItemType,State,Severity,AreaSK “

        &”&$expand=AssignedTo($select=UserName),Iteration($select=IterationPath),Area($select=AreaPath) “

    ,null, [Implementation=”2.0″,OmitValues = ODataOmitValues.Nulls,ODataVersion = 4])

in

    Source

 

• Then you have a matrix for Open Bugs

 

Hope this can help.