Forum Discussion
Concatenate formule in direct query
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
Hi Anonymous ,
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.
3 Replies
- amitchandak
Super User
Anonymous , not very clear. You can use combinevalues, in case you want to join two columns https://youtu.be/rzbtXQrq43Y
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...
Hi Anonymous ,
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.
