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.

     
niting's avatar
niting
New Member
4 years ago

Hello - I am also facing a similar issue. I m trying to pivot an appended table. please refer to the below screenshots. I want to pivot cost category and the values are in Value column. I get an error saying "Couldnt convert to numbers .....Details: Connectivity". Value column is in fixed decimal number format.