Get capacity from Azure Devops using Dataflow Gen 2

Hi all, I'm trying to get capacity from Azure DevOps using Dataflow Gen 2.

After having the table containing all IterationId in the project, I used the following step to loop through each Id and get Capacity data.

=Table.AddColumn(#"Added Working Day", "Capacity", each try Json.Document(Web.Contents("http://dev.azure.com/ProjectName/_apis/work/teamsettings/Iterations/"&[IterationId]& "/capacities")) otherwise null

However, I get the error of credentials. I already checked and guaranteed that my credentials are correct. And when I filtered to get only 3 IterationId or less, the queries ran. Is there any limit in Fabric when getting data using a loop? Do you have any better solutions to retrieve Capacity data?

3 comments