Forum Discussion
Data format error on refreshing data from Excel
I have a table of Sales, that contains column of Invoice number. The data contains numeric and alpha numeric invoice numbers
(2245568, M-25874, 225984-V, etc...)
Have been able to import the Excel and refresh with no problems.
Yesterday began receiving an error "DataFormat.error We couldn't convert to Number..."
Seems that it changed or thinks the Invoice Number column is a numeric column.
I went into the edit query , and saw that the column type was changed to 123(numeric), and changed back to ABC text.
Still getting the "DataFormat.error We couldn't convert to Number..."
I upgraded to the September release in between allof this.
Any help would be greatly appreciated.
Thanks
5 Replies
Hi pablo262,
Since I can’t reproduce your issue, can you share me a test sample to reproduce it? Or provide some detail information about this issue.(e.g. power query formula, screenshots, records)
Regards,
Xiaoxin Sheng
Did you solve it? I have exactly the same issue using Power query in Excel.
did you manage to solve it? besides deleting the offending column (not an option for me).?
I am also having this issue. I have an org code column with an overwhelming majority of numeric only data. A tiny subset has Alphanumeric. On refresh, it keeps changing the data type to numeric, even after manually changing to text. Even if I go to the supporting excel spreadsheet and force the data into text at that level, the import still converts the data to a number. I even tried sorting the dataset to force the cells with alphanumerics to the top (hoping when power bi went to preview, it would adhere to the sort order and recognize the datatype)....no luck.
I am also having this issue. I have an org code column with an overwhelming majority of numeric only data. A tiny subset has Alphanumeric. On refresh, it keeps changing the data type to numeric, even after manually changing to text. Even if I go to the supporting excel spreadsheet and force the data into text at that level, the import still converts the data to a number. I even tried sorting the dataset to force the cells with alphanumerics to the top (hoping when power bi went to preview, it would adhere to the sort order and recognize the datatype)....no luck.
