Today I want to show you how you can use Power BI to analyse your projects statistics.
We can do it directly on a website. For example, when we create our own query, in this case I’ve created “All items” query.
We and pick this query and go to Chart tab, where we can make simple charts.
It is good resolution in many cases. But when we want do more complicated or flexible analysis, we can use Power BI.
Using Azure DevOps datasource we can access to data from Azure Boards.
We have access to views from Analytics Views.
Analytics views need to be enabled and users need to have credentials assigned. Details are in Microsoft Docs.
Here is a report example.
Here is a .pbix file.