Forum Discussion

adciudad's avatar
adciudad
Icon for Helper II rankHelper II
8 years ago
Solved

combine columns in direct mode

is it possible to combine columns in direct mode?   I need a relationship between two tables, but this relationship is composed of 3 fields
Need Help
Tutorial Requests
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi adciudad,

     

    In DirectQuery mode, combining columns is not supported. As a workaround, you can achieve this by creating a calculated column with DAX function: CONCATENATE

     

    Best regards,

    Yuliana Gu

LivioLanzo's avatar
LivioLanzo
Icon for Solution Sage rankSolution Sage
8 years ago

Yes, combine them within your query, make sure Query Folding happens

adciudad's avatar
adciudad
Icon for Helper II rankHelper II
8 years ago

 

i have 3 fields, PTRABAJO, ABER, NCOMPROB, when i want join to 1 field, power bi tell that not compatible in mode DirectQuery