Forum Discussion
Radhika123
Helper I
Helper IText 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...
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.
Radhika123Helper I
Helper II 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
Skilled Sharer
Skilled SharerHiii,
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!!!!