Forum Discussion
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...
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.
Hi Khushidesai0109 ,
Thanks for the reply.
please check the snap shot above . I had changed the column to text ,but it didn't work.
Hii,
Have you applied it and closed it, please check in the table view as well