none
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.


    Thanks!!!

    Tuesday, January 16, 2018 11:58 AM

Answers

  • 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. http://blogs.msdn.com/peter_qian

    Wednesday, January 17, 2018 10:20 PM