Скачать с ютуб From Azure DevOps to Power BI - Retrieving Sprints and Pipelines information through API calls в хорошем качестве

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/res... 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/res... Pipelines API reference: https://learn.microsoft.com/en-us/res... 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