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.

skygold16's avatar
skygold16
Helper II
2 years ago

Hi There, 

 

Did you try changing the column data type to text while loading data thorugh Power Query ?

 

Thanks,

 

Radhika123's avatar
Radhika123
Helper I
2 years ago

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

Thanks.

  • skygold16's avatar
    skygold16
    Helper II
    2 years ago

    What error do you see?

    • Radhika123's avatar
      Radhika123
      Helper I
      2 years ago

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

       

  • MNedix's avatar
    MNedix
    Solution Sage
    2 years ago

    Radhika123  Can you paste a snippet of your data?

    • Radhika123's avatar
      Radhika123
      Helper I
      2 years ago

      Hi MNedix .Thanks for th reply
      Please find the snap shot.