Hi,
In SSAS Tabular Model, we the cannot import from a varchar(max) column that contains a string length of more than 131,072 characters.
This is the limitation for DAX data type, you have to truncate into shorter string to separate into two columns.
There's no effective workaround.
Please see reference here : Data types used in tabular models
Regards,
Lukas