Hi all, Now I only see people connect between Fabric and SSMS using email (user name). I want to know if we can connect by using other ways like password? My goal is to get data from Fabric so that ChatGPT can access and analyze. Thanks a lots 😄

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?