Cross reference table column with multiple values in Fabric Dataflow

Hello, We are working on dataflow in fabric and running into a problem, where we were unable to look up information dynamically. Eg: We have Tbl_ref which has following info ref_ID  ref_type  Sys...