Error in column format

[Thyago_Rezende]

Why do Power BI return the error below about the column format, even the column format is Text and not Number.

[MFelix]

"Hi @Thyago_Rezende,

You need to change the format for that column to text on the step "Change Type".

Regards,

Mfelix

[Thyago_Rezende]

Hi @MFelix,

Thanks for your support. 

I did it. But it does not work. The Power BI doesn´t recognize the Text format. 

[Thyago_Rezende]

Look at the CNPJ column was formatted as Text (ABC) and it content is text (N/D).

[MFelix · Accepted solution]

Hi @Thyago_Rezende,

You need to go to a previous step on your query and change it. The better way is to go to that step choose Text format, it will ask you to replace the step and then check the value at the end.

.

Regards,

MFelix