Forum Discussion
Quiny_Harl
Advocate III
4 years ago"Conversion failed when converting the varchar value to data type int" error when add custom column
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...
- 4 years ago
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
mahoneypat
Microsoft Employee
4 years agoYou 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