Forum Discussion
Refresh Error: OLE DB or ODBC error: [Data.Format.Error]. We couldn't convert to Number..
Hi,
Has anyone had this error before please?
I would open up the Excel file and look at the column values. I would even copy all the column values and paste it in a new tab and click on "remove duplicates" in Excel to see all the possible values. I guarantee you that there is at least one value that is not numeric/number.
3 Replies
You have an alphanumeric column in your data that you are trying to conver to number. Go through your Power Query steps and find out which step is causing it. If you need that column conveted to number type, then check your data for any text values in that column that can't be converted to number (example "Abc", etc.); there should be at least one.
Ive checked and I dont seem to? My data is extracted from excel and I have checked there but everythign seems to be ok?
I would open up the Excel file and look at the column values. I would even copy all the column values and paste it in a new tab and click on "remove duplicates" in Excel to see all the possible values. I guarantee you that there is at least one value that is not numeric/number.
