Forum Discussion
How To Import Comma Delimited Values Within a Single Column
Hi WinterMist
When PBI imports the data and after some steps it auto adds a Change Type step.
You could delete this step to prevent it assigning the numeric data type.
Or click on the step when you change the datatype and see this message:
Choose Replace current to ensure that this column was ALWAYS text.
Not converted to number and back to text.
Alternitvely modify the M of the changed type step.
Change this from type Number to type text.
My guess is that your data has changed. The data type is based on the first 1000 rows, in the past maybe the first 1000 only had numbers.
Hi WinterMist
When PBI imports the data and after some steps it auto adds a Change Type step.
You could delete this step to prevent it assigning the numeric data type.
Or click on the step when you change the datatype and see this message:
Choose Replace current to ensure that this column was ALWAYS text.
Not converted to number and back to text.
Alternitvely modify the M of the changed type step.
Change this from type Number to type text.
My guess is that your data has changed. The data type is based on the first 1000 rows, in the past maybe the first 1000 only had numbers.