Forum Discussion
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.
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.
You can replace the values before/after the unpivot or replace the error with some value or nothing...
Or even change the date format before the operation.