From Azure DevOps to Power BI - Retrieving Sprints and Pipelines information through API calls

Key Links:
Query Structure for Power Query:

Azure DevOps REST API reference - https://learn.microsoft.com/en-us/rest/api/azure/devops/?view=azure-devops-rest-7.2

let
Source = VSTS.Contents("INSERT API REFERENCE"),
#"Imported JSON" = Table.FromRecords(Json.Document(Source,65001)[value])
in
#"Imported JSON"

Iterations API reference: https://learn.microsoft.com/en-us/rest/api/azure/devops/work/iterations/list?view=azure-devops-rest-7.1&tabs=HTTP

Pipelines API reference: https://learn.microsoft.com/en-us/rest/api/azure/devops/pipelines/pipelines/list?view=azure-devops-rest-7.2

Description:
In this video, we explore how to leverage the Azure DevOps REST API to retrieve and display key data like release pipelines and sprints / iterations in Power BI. We walk through step-by-step how to use Power Query to structure API calls, transform JSON data, and build dynamic reports to view sprint tasks and pipeline runs.

Topics covered:

- Accessing the Azure DevOps REST API Reference
- Displaying release pipelines in Power BI
- Connecting sprint data and work items to create a report
- Building relationships between sprints and work items

Have questions? Drop - them in the comments, and don't forget to subscribe for more content like this!

Chapters:
00:00 - Introduction to the Video
00:16 - Overview of Azure DevOps API and Community Questions
00:33 - Exploring API for Release Pipelines and Work Items
01:12 - Introduction to Azure DevOps REST API Reference
01:31 - Filtering API for Pipelines
01:44 - Retrieving Sprint Data (Iterations)
02:10 - Using Power Query to Import Data into Power BI
02:53 - Structuring API Query for Azure DevOps Data
03:37 - Setting Up Organization, Project, and Team in API Query
05:13 - Listing Sprints and Pipelines in Power BI
06:08 - Accessing Pipeline Runs
07:24 - Viewing Work Items Associated with Sprints
08:13 - Creating Relationships Between Sprints and Work Items
09:11 - Building a Power BI Report with Sprint Data
10:02 - Filtering and Displaying Work Items by Sprint and Type
12:05 - Summary of API Usage and Power BI Integration
12:51 - Final Thoughts and Next Steps

Видео From Azure DevOps to Power BI - Retrieving Sprints and Pipelines information through API calls канала Paying it Forward