Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Post Prodigy
8 years ago
Solved

Direct Query- multiple column relationships?

Our vendor system that we are using as a data source has several tables that use a combination primary key and for relationships to other tables you have to join on 3 or 4 columns (I hate it, I do no...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi OneWithQuestion,

     

    In Direct Query, you are still able to create a calculated column to combine multiple columns to generate the primary Key.

    Col4 = Test5[Col1]&" "&Test5[Col2]

    ColC = Test6[ColA]&" "&Test6[ColB]

     

     

    Best regards,

    Yuliana Gu

koureass's avatar
koureass
Regular Visitor
3 years ago

UPDATE 07/07/2023 in behalf of my previous post

I have tested this on tables with million of rows using Direct Query, very very bad idea...