Forum Discussion
DataFormat.Error: We couldn't convert to Number.
DataFormat.Error: We couldn't convert to Number.
Details:
EVP00452725
Why stupid PBI want convert TEXT column to number?
7 Replies
Digger , The one in green seem like text - EVP00452725, First you need remove text part
refer
https://goodly.co.in/separate-numbers-from-text-excel-powerquery/
amitchandak why i need remove if i dont want to remove? it text not number, i DO NOT WANT CONVERT TEXT TO NUMBER !!!!!!!!!!!!!!!!!!!!!!!
Digger , Not very clear. It is showing text in the number column. You do not want convert. DO you thing it is giving wrong error.
Can you share sample data and sample in table format including the error row data
