Not able to connect POwerBI desktop with Azure Devops Sprints Data

[GiriPrasad_21]

Hi Team,

While connecting PowerBI with Azure Devops , I am able to connect ony with "Analytics View" Data.But requirement is need to retrieve sprint Capacity data within PowerBI.

Tried with couple of API;s, but haven't found the solution for it.

May i know any solution is available for the above scenario.

[rajendraongole1]

Hi @GiriPrasad_21 - Unfortunately, there isn't a direct integration from "Analytics Views" for capacity data.

you may want to look into below solved and ref. documents:

Solved: Is it possible to connect Azure sprint capacity da... - Microsoft Fabric Community

Solved: how to fetch azure devops team capacity into power... - Microsoft Fabric Community

• Azure DevOps REST API Documentation
• Power BI with Azure DevOps API blog posts or GitHub examples where many users share API integration solutions.

Hope this helps.