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.

Radhika123's avatar
Radhika123
Helper I
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.