DevOps Data into Power BI

Power Platform - General

The article discusses how to use Power BI to report on data from Azure DevOps.
OData queries are used to connect Power BI to DevOps, starting with a simple query for Work Items.
The article provides a step-by-step guide on how to select columns and build OData queries in Power Query.
Additional tables like Users and Calendar can also be pulled into Power BI using the same pattern.
The article emphasizes the importance of modeling relationships between tables and creating measures for analysis.
Two measures are created for total hours and the count of items in the dataset.
Visuals like tables and tree maps are used to present the data in Power BI.
The article concludes by mentioning the limitations of the current model and the potential for future enhancements like adding a Parent-Child hierarchy.

Registered users can view the full text for FREE!