Text and numbers in same column.

[Radhika123]

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 is showing errors where the text is present .Please help me in this.

Thanks in Advance.

[Radhika123 · Accepted solution]

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]

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]

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]

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]

Thanks @Khushidesai0109 , then what might be the problem with my data source . I have set that column to text itself, like you have done.

[Khushidesai0109]

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]

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!!!!

[Radhika123]

Hi @Khushidesai0109 ,
Thanks for the reply.

please check the snap shot above . I  had changed the column to text ,but it didn't work.

[Khushidesai0109]

Hii,
Have you applied it and closed it, please check in the table view as well 

[skygold16]

As error shows, there is a text value in the field and I think you need to look at your Power Query steps which is trying to convert the column to a text datatype. If you want to use numeric and text value together, you need to keep the column data type as string. Or you can filter our the value which is non-numeric. 

[Radhika123]

I have changed the column type to text in power Query , but it didn't work. Need to try to filter value to non numeric. Will try and let you know.And that column is a choice column in share point list .Is that the reason for this issue ?

[skygold16]

Hi There, 

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

Thanks,

[Radhika123]

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

Thanks.

[MNedix]

@Radhika123  Can you paste a snippet of your data?

[Radhika123]

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

[skygold16]

What error do you see?

[Radhika123]

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