Saturday, April 27, 2019

Azure DevOps Data in PowerBI

Recently I was able to tryout the Azure DevOps connector for PowerBI and visualize some crazy charts to see the work in progress for one of the organizations. It is still at Beta stage but looks solid with the way how it behaves.

You can simply search and find it on the connector search when you go to Get Data button and click on the More option down.




As it is in Beta, you will be requested to share your experience data. You can opt to do or not and then you have to specify your DevOps project organization and the project you wish to connect. Thereafter, you will be prompted to authenticate if not already.

Once authenticated, you can select 'Tasks - all history by month'. This will get the list of tasks synced in.

In the report Window, you can select a report of your choice based on the need.


You will get all the custom fields specified in DevOps project with their data type. If you need, you can go back to the data model and change the data type if necessary. (eg: Text to Number)

An important thing to keep in mind is the 'Is Current' property of the data. Once you set that to true, you will only get the current version of the data set.

So why wait? Try it out.

2 comments:

  1. Thanks a lot very much for the high quality and results-oriented help. I won’t think twice to endorse your blog post to anybody who wants and needs support about this area.
    Devops training in chennai| Best Devops training in chennai | Best Devops training institute in chennai
    | Devops certification in chennai | Devops course in chennai

    ReplyDelete
  2. The report likewise gives the focused scene to the man-made brainpower advertise, in this way situating all the real players as per their geographic nearness, showcase engaging quality and late key improvements. artificial intelligence training in pune

    ReplyDelete