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

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).

      • MFelix's avatar
        MFelix
        Super User
        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