combine columns in direct mode

[adciudad]

is it possible to combine columns in direct mode?

I need a relationship between two tables, but this relationship is composed of 3 fields

[v-yulgu-msft · Accepted solution]

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

[Anonymous]

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

[adciudad]

Thanks !

[LivioLanzo]

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

[adciudad]

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

[LivioLanzo]

You cannot do TransformColumnTypes in Direct Query