Forum Discussion
mariussve1
Solution Sage
Solution SageHow can I loop through a list as soruce in Power Query?
Hello. I am creating a model based on DMV's in Power Query, and now I want to loop through a list of all databases in one workspace, so I dont need one model for each database, but instad I want t...
mariussve1Solution Sage
Solution SageNot sure if this is correct, but my query to extract the list of models with API is now converted to a list. I can now use this list as a query into the Database parameter. I now want to invoke this list so it can loop through, but still stucked.
Marius
ppm1Solution Sage
Solution SageYou can loop through your list with List.Generate or List.Accumulate but it would be easier to just convert your initial list to a table and then add a custom column where you concatenate the dataset id into an API call on each row.
Pat