Data Error when column contain Both Number and Text

[allenpee85]

Hi all,

One of the columns contain both Text and Number, therefore it caused my query M unable to recognize and shown error.

Anyone know how to resolve this so that Power BI know how to read?

Thanks.

[Sumanth_23 · Accepted solution]

hi @allenpee85 - Can you share details on what error you are seeing? Also if you format the column as text you should be able to proceed with processing the data. 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!