Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
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.