"Conversion failed when converting the varchar value to data type int" error when add custom column

[Quiny_Harl]

Hello folks,

I need to create a composite key column by combining several columns:

However, I get the following error message: 

"DataSource.Error: Microsoft SQL: Conversion failed when converting the varchar value '|' to data type int."

I suppose the reason for this is because some of the columns are of a type int and some are of a type text and those that are of type int need to be converted to text. However, for the purpose of query folding, I'm not allowed to change the column type (or at least this is what the documentation says). Is there any workaround for this?

[mahoneypat · Accepted solution]

You can wrap the non-text columns with Text.From in your expression.  If that won't fold, you could always make your column with a DAX expression after the table is loaded.

Pat