Issue with column data type and showing errors

[dinesharivalaga]

Hi Experts,

I am facing an issue with the data type for the column below :

From the data source (Sharepoint list) , also having whole numbers , in that case i dn't know which data type to choose from power query.

I cannot able to fix this as i have tried to change data type into "text" but still it is not fixed. showing errors of 369 rows .

Please help to fix this asap

Thanks

DK

[lbendlin]

Those are text values, not integers.

[dinesharivalaga · Accepted solution]

@lbendlin  I have updated the text data type in M code and it is sorted now . Thanks 🙂

[dinesharivalaga]

@lbendlin yes but tried to change as "text" data type but not fixed , still error exists 😞