Concatenate formule in direct query

[JimmyCruyp]

Hello everyone,
we work in direct query. I need to create a concatenation formula. It does not work. Can you tell me if it is impossible to create a simple concatenation formula when we are in direct query? It's basic though.
THANKS

[v-yangliu-msft · Accepted solution]

Hi  @JimmyCruyp ,

According to the official limits of the formula:

This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Refer to:

CONCATENATE function (DAX) - DAX | Microsoft Learn

This is the related document, you can view this content:

concatenate Text in direct query mode - Microsoft Power BI Community

Solved: Isblank function and concatenate in Direct Query - Microsoft Power BI Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@JimmyCruyp , not very clear. You can use combinevalues, in case you want to join two columns https://youtu.be/rzbtXQrq43Y

[JimmyCruyp]

@amitchandak I have exactly the same problem as concatenate formula : in direct query : OLE DB or ODBC Error So it doenst work. : impossible to load data...