Fetching Test Plans and Linked Test Cases from Azure DevOps to Power BI

Take this:

1. Set Up API Access

• Ensure you have access to the Azure DevOps organization and project.
• Generate a Personal Access Token (PAT) in Azure DevOps to authenticate API requests.

2. Fetch Test Plans

• Use the Test Plans API to retrieve the list of test plans:

GET https://dev.azure.com/{organization}/{project}/_apis/test/plans?api-version=6.0

Replace {organization} and {project} with your Azure DevOps organization and project names.

3. Fetch Linked Test Cases

• For each test plan, use the Test Cases API to fetch linked test cases:

GET https://dev.azure.com/{organization}/{project}/_apis/test/plans/{testPlanId}/testcases?api-version=6.0

4. Connect to Power BI

• Open Power BI and use the Web Connector to make API calls.
• Enter the API URL and authenticate using your PAT.

5. Transform Data

• Use Power BI's data transformation tools to structure the data as needed.
• Create relationships between Test Plans and Test Cases for reporting.

6. Automate Updates

• Schedule data refreshes in Power BI to keep the reports up-to-date.