Search code examples
azure-devopspowerbireportingproject-management

DevOps reporting across all projects

Just to throw this into the pond, what's the best way to get some reporting visibility for DevOps's workitems across all projects in a single view.

i.e. 

Resource: John Smith
Date from: dd/mm/yyyy to: dd/mm/yyyy

Project | Type         | Name  | Etc.
-------------------------------------
Prj1    |  Epic        |  XXXX | XXXX 
Prj1    |  Feature     |  XXXX | XXXX 
Prj1    |  User Story  |  XXXX | XXXX 
Prj1    |  Task        |  XXXX | XXXX 
Prj1    |  Task        |  XXXX | XXXX 
Prj2    |  Feature     |  XXXX | XXXX 
Prj2    |  User Story  |  XXXX | XXXX 
Prj2    |  User Story  |  XXXX | XXXX 
Prj2    |  Task        |  XXXX | XXXX

What's the best way to pull this kind of reporting setup into PowerBI. I find the default connector is just not sufficient enough, perhaps there is a better way to pull an OData query out.

Solution

  • For this issue, you can create a query directly in Queries,check Query across projects option and customize the columns that need to be displayed through the Column options button.

    enter image description here

    If you want to integrate with Power Bi, there are currently two methods available: Analytics view and OData queries.

    Analytic view : you need to add all your projects in Teams and customize the columns that need to be displayed in Fields.

    enter image description here

    enter image description here

    You can refer to this guide for details.

    OData queries : In this way ,you need to construct organization-scoped queries to return work items of interest . You can refer to this document for samples.