Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Is it possible in Power Query's M Language to have a query parameter in the API string that will iterate through a list of values that are in a separate query/column and ultimately merge the results into a single result set that also appends that same value to the final result set.
Hello @djanszentql
you have to do it the other way round. Use your column/list to iterate through (List.Transform) and apply on each step your api-call. Then you will have a list of api calls (with tables or lists). After that you can combine your result with List.Combine or Table.Combine.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Can you explain what you mean by "apply on each step your api-call". I have to specify the API call multiple times? Doesn't that defeat the purpose of iterating through each row dynamically?
Hello @djanszentql
I give you a short example with a list. The web.contents is launched 3 times and using the list item as parameter for the web-call
let
Source = {1,2,3},
CallWebAPi3Times = List.Transform(Source, each Web.Contents("YourUrl" & Text.From(_)))
in
CallWebAPi3Times
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy