Forum Discussion

Anirudh_Test's avatar
Anirudh_Test
Copper Contributor
Mar 24, 2025

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

Hi ,

 

When I fetch the data from ADO I do not see the Test plans and associated test cases on it , please help me in fetching it

1 Reply

  • Kidd_Ip's avatar
    Kidd_Ip
    MVP
    Mar 25, 2025

    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.

     

Resources