Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.