Forum Discussion

tsuirs's avatar
tsuirs
Frequent Visitor
9 years ago
Solved

Error: Cannot convert to number for Number column in Excel with null values

I imported an Excel workbook with data detection set to based on first 200 rows. For one column in Excel, it contains whole number and there are a few rows  with null value.   Power BI returned Er...
Need Help
  • tsuirs's avatar
    tsuirs
    9 years ago

    Found the issue.  There is unprintable characters in the cell.  Once fixed, everything is fine.  Thanks for everyone help!

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I am facing the same issue but in only 5 specific cells. When I reove the values, the error goes away. If I again put any values in those 5 cells, the error pops up again. I have wasted so much time trying to figure it out but nothing seems to work. I even created a completely new file and only pasted values in it but same error comes. 

 

The excel file is available here. Need your help guys!!! 

https://docs.google.com/file/d/1nxfpRn5SMGtE8_Z0S82mKE9OzGLVjb5b/edit?filetype=msexcel

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

The error I get is cannot convert to date. The data being used is numbers and the format is also in decimal but I do not know why power bi is trying to convert it to date. Please help!