Fabric question, for each row of table perform action

[BIanon]

Hello Community,

I am playing around with my Fabric demo currently and was wondering, where I would go to accomplish the following scenario:

For each row in Table A, grab and ID and use as filter on Table B, then merge Table B with Table C to ultimately produce a unique table for each of the rows in Table A to be consumed in a PBI dataset.

Would this be a Dataflow + Datafactory task? I am new to many of the Fabric features but would like to learn a lot more

[GilbertQ · Accepted solution]

Hi @BIanon 

I would be looking to use Dataflow Gen2 to do this. You could test this all out in Power BI Desktop and then copy the queries across to dataflow Gen2 in Fabric!