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!

     

     

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

tsuirs

 

Could you please provide the excel workbook which can be used to repro this issue? I tested on my side but cannot repro the same issue. Please refer to following screenshot.

 

 

Best Regards,
Herbert