Forum Discussion

adciudad's avatar
adciudad
Icon for Helper II rankHelper II
7 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
    7 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

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 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

  • adciudad's avatar
    adciudad
    Icon for Helper II rankHelper II
    7 years ago

    Thanks !

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-yulgu-msft adciudad 

    This doesn't work for me with BigQuery.

    I've created a composite key using CONCATENATE (same happens when I use COMBINEVALUES).

    But when I create a visual that includes the composite key, I get this error:
    OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression..

    Can you help?

    Best