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 data type of these columns to 'any' and 'text' with no luck.

 

Please see photo below. All your help is greatly appreciated

 

7 Replies

  • 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