Get Azure DevOps Sprint Capacity data through Rest API into PBRS for last six sprints

Hi Rajesh-Kolli 

Here are some offical blogs for you, I hope they could help you.

For reference:

Connect with data by using OData queries - Azure DevOps | Microsoft Docs

Connect to Power BI Data Connector - Azure DevOps | Microsoft Docs

If you need use Azure DevOps API, please refer to the code below.

let
    Source = Json.Document(
        Web.Contents(
            "https://dev.azure.com/{organization}/{project}/_apis/work/teamsettings/iterations/{iterationId}/capacities/{teamMemberId}?api-version=6.0"
        )
    ),
    #"Converted to Table" = Table.FromRecords({Source})
in
    #"Converted to Table"

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.