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

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.

Khushidesai0109's avatar
Khushidesai0109
Skilled Sharer
2 years ago

Hiii,
Please See this the data format is correct and can view as well
Thank You
If this helped you please give thumbs up and accept it as solution!!!!

  • Radhika123's avatar
    Radhika123
    Helper I
    2 years ago

    Thanks Khushidesai0109 , then what might be the problem with my data source . I have set that column to text itself, like you have done.