Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Loop through a list and using the values to generate a new table

Hello

 

I'm a newbie in power bi, I am trying to generate a new table using two steps :

 

1. Retrieving initial data needed for the second step.

I use an api call and get a column with 'Id' as follows. In this example, I only have one but I'm supposed to have a much larger list of just Ids

 

2. Each one on these Ids will then need to be used individually for another api call : "getItem(Id)". So in this case, getItem(414483025). This will then give me a row for my data

 

I want in the end to have a table with all the combined rows, how can I achieve that ? I assume I need a function ? 

 

Thanks a lot!

 

 

 

1 Reply

  • in your table, add a column that calls getitem([Id])  (note the square brackets)

    then you can expand that column and grab the fields you need for your final table.