Column error

[Syndicate_Admin]

Hello good morning. I'm getting into Power BI and I have an error. I upload a file where one column includes the Nit of my clients but there are numerical values and others are text and numeric values. Text values and numbers come to me in error. In this case how you could fix it. ?

A thousand thanks

[Syndicate_Admin]

Thank you very much if it worked for @Syndicate_Admin

[Anonymous]

Hi @TiqueteOfertas ,

Whether your problem has been resolved? If no, you can try to delete the step "Change Type" and check whether it can works later.  Could you please provide the related screenshot with error message and applied codes in Advanced Editor if the previous method is not working for your scenario?

Best Regards

[AllisonKennedy]

@Syndicate_Admin  @TiqueteOfertas 

You can fix this in Power Query - click 'Transform Data' in the Power BI desktop, then find the table with the error. On the right hand side under 'Applied Steps' look for the 'Changed Type' step. Select this step. Now change the data type for the column to 'Text'. Click 'Yes' to the question do you want to insert. Click 'Replace' to the question about replace or add new. 

Close and apply changes. Refresh data. It should work now.