Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DataFormat.Error: We couldn't convert to Number.

Hello all,   I was hoping you could help me. I receive the error DataFormat.Error: We couldn't convert to Number.   This occurs in columns which I want to display text. I have tried changing the ...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous,

     

    You may just change the fourth step.

Maddy99's avatar
Maddy99
Resolver II
7 years ago

Can you show a pictures of how the data was before this step?

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi, 

 

Thanks for the response. The data looked pretty much the same. 

 

I dont understand why it is trying to convert to a number in the firtst place, as it is the text values I want. I have removed the last step in power query.

 

 

Thanks

 

Dom

  • Maddy99's avatar
    Maddy99
    Resolver II
    7 years ago

    Power BI may have create the change type step automaticly .

    on the right side you see the applied steps window. there you can remove the step. 

     

    but i dont realy understand your question.

    1) do you want to change te date to a numer

    2) do you NOT want to change your data type?

     

    mvg,

    madelon

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      So, I would like to keep the column as text. However, when I change data type to text (as I want), I get the error message.

       

      The column only contains text values, and I want that to stay. 

       

      I hope this is clear.

       

      Thank you

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Please see the text I would like to be displayed in the error message