Forum Discussion

Radhika123's avatar
Radhika123
Helper I
2 years ago
Solved

Text and numbers in same column.

I have a column called "Task ID" in share point list which is having some rows with numbers and some rows with text , but when i load to power BI I'm not able to see the text rows data , instead it i...
Tips and Tricks
  • Radhika123's avatar
    Radhika123
    2 years ago

    Hi Khushidesai0109 ,
    skygold16 ,
    MNedix 
    Thank you so much for your replies, I got the answer for the question I have asked.
    I changed the data type to 'any', in advance advance editor of power query.

    Thank You,
    Radhika.

skygold16's avatar
skygold16
Helper II
2 years ago

As error shows, there is a text value in the field and I think you need to look at your Power Query steps which is trying to convert the column to a text datatype. If you want to use numeric and text value together, you need to keep the column data type as string. Or you can filter our the value which is non-numeric. 

Radhika123's avatar
Radhika123
Helper I
2 years ago

I have changed the column type to text in power Query , but it didn't work. Need to try to filter value to non numeric. Will try and let you know.And that column is a choice column in share point list .Is that the reason for this issue ?