Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
djanszentql
Helper I
Helper I

Power Query Dynamic Parameter from Column Values

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.

3 REPLIES 3
Jimmy801
Community Champion
Community Champion

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.