-2

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.

M--
  • 25,431
  • 8
  • 61
  • 93
the.herbert
  • 289
  • 1
  • 5
  • 14

1 Answers1

0

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.

Hugh Lin
  • 17,829
  • 2
  • 21
  • 25
  • Thanks.. I think OData queries may be the way to go here coz the queries can be more granular. What's the best approach for the queries, Is it recommended to query directly to DevOps on demand? or Is it worth pulling the data on scheduled basis and keep them in a DB somewhere? – the.herbert Jan 22 '20 at 22:35