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.
Hiii
The error shows that you changed the data type of that column to number
Please see the table view and in that select Text
or Go to power query and change to datatype of column to text
Thank You
If this helped you please give thumbs up and accept it as solution!!!!
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