Forum Discussion

bobbiclancyABB's avatar
bobbiclancyABB
New Member
5 years ago
Solved

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

Hello Everyone, I'm trying to pivot on a table that I'm editing in the PowerQuery but I keep getting a DataFormat Error and the pivot isn't working.       
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi bobbiclancyABB ,

    Based on the error message, the "%" cannot be converted to NUMBER type. What is the data type of the column which includes '%'?

    If the column is a number type but with '%' or other chararcters in it, it should be a text column.

    Please check the column formats next to the column. On the applied steps, locate "Changed Type", change the format of the column to text, and click replace current step when asked. 

     

    Best Regards,

    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     
Charlieburden8's avatar
Charlieburden8
New Member
3 years ago

I am also having the name issue. My cells contain both numbers and letters and whenever I try to 'change type' nothing seems to remove the error. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I too have this problem. but nothing in these comments seems to help. Did you find a solution jet?