Forum Discussion
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...
Hello Element115, Thank you for your response. We are using data factory persona for our ETL not power BI to use M code
Data factory... so I guess dataflows gen 2, or DFg2, which is an ETL tool. In fact, it is Power Query in the cloud. So, when you right click on any query in your DFg2, you can select Advanced editor from the contextual menu and it will show you the M code for the query.
For debugging purposes, and curiosity's sake 😉, once the Advanced editor is open, you can select all and copy the code, and then paste it into Power Query Desktop to see if it causes the same issue. If not, then we would have determined that it is something specific to Power Query in the cloud, ie DFg2. When you have time, of course.