Merge 2 column in Direct Query RRS feed

  • Question

  • I have 2 table tbl1 & tbl2. Both the table have "ProductID" & "ProductVersion" column. For making the relationship between both the tables, I need to link "ProductID" & "ProductVersion" columns in both the tables and both the columns contains duplicate value.

    I am using Power BI in Direct Query mode.

    Solution that I am trying is that create a column by merging "ProductID" & "ProductVersion" in both the tables but I am not able to merge column in Direct Query mode.

    I have also tried creating a new column "Product_ID = tbl1[product_key]&" "&tbl2[product_version]"

    But that way too I am getting an error which says "we couldn't fold the expression to the data source. Please try a simpler expression."

    Please help me.


    Tuesday, January 16, 2018 11:58 AM


  • I think what you are looking for is a composite key relationship? Once you connect to both tables, define a relationship with both columns as key, then it should work.

    Merging data across tables isn't supported in DirectQuery mode.

    Peter Q.

    Wednesday, January 17, 2018 10:20 PM