Forum Discussion

allenpee85's avatar
allenpee85
Helper I
5 years ago
Solved

Data Error when column contain Both Number and Text

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?  ...
  • Anonymous's avatar
    Anonymous
    5 years ago

    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!