Help concatenate fields

[Syndicate_Admin]

Hi everyone, someone could support me in telling me how I can concatenate two columns if I am using the Direct Query connection mode, and it does not let me use CONCATENATE, what would be the option?

I appreciate your support.

[onurbmiguel_]

hi @Syndicate_Admin 

Plase look at the modeling limitations when we are in DQ 

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about#modeling-limitatio...

But try this calculation: 

New Column = 'Table'[Column1] & " | " & 'Table'[Column2]

Best regards

Bruno Costa | Power Participant

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

You can also check out BI4ALL's website and our data solutions!