Forum Discussion

newtofabric's avatar
newtofabric
Regular Visitor
2 years ago

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...
Dataflows
Need Help
Element115's avatar
Element115
Memorable Member
2 years ago

Try to run the same M code in Power Query Desktop to see if you get the same error. That way we can determine if it is a Power Query Fabric issue or just a general Power Query engine issue.

 

Also, are you using a DFg1 or DFg2?  In other words, did you create the DF from the Power BI persona, or the Data Factory persona?

  • newtofabric's avatar
    newtofabric
    Regular Visitor
    2 years ago

    Hello Element115, Thank you for your response. We are using data factory persona for our ETL not power BI to use M code

    • Element115's avatar
      Element115
      Memorable Member
      2 years ago

      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.