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.

Khushidesai0109's avatar
Khushidesai0109
Icon for Skilled Sharer rankSkilled Sharer
2 years ago

Hiii Can you please send the column details as well like copy the column data and paste it here so I can see whats the major issue is

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

I have done close and apply in power query , and I found blanks where the text present.

--------
8224347
8224347
Cubix_TE
Cubix_TE
Cubix_TE
Cubix_TE
Cubix_TE
Cubix_TE
Cubix_TE
Above is the data from that column.And that particular column is a choice column.