Forum Discussion

Quiny_Harl's avatar
Quiny_Harl
Advocate III
4 years ago
Solved

"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...
  • mahoneypat's avatar
    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