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.

Khushidesai0109's avatar
Khushidesai0109
Skilled 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
    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!!!!

    • 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.