Forum Discussion

Thyago_Rezende's avatar
Thyago_Rezende
Resolver I
8 years ago
Solved

Error in column format

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

Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    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

4 Replies

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    "Hi Thyago_Rezende,

     

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

     

    Regards,

    Mfelix

    • Thyago_Rezende's avatar
      Thyago_Rezende
      Resolver I
      8 years ago

      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's avatar
        Thyago_Rezende
        Resolver I
        8 years ago

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