Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.