Forum Discussion

Radhika123's avatar
Radhika123
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper I
2 years ago

Hi skygold16 ,
Thanks for your reply.
yes , I have tried in that way also.

Thanks.

skygold16's avatar
skygold16
Icon for Helper II rankHelper II
2 years ago

What error do you see?

  • Radhika123's avatar
    Radhika123
    Icon for Helper I rankHelper I
    2 years ago

    Hi skygold16 .
    I'm getting the error as above.