Forum Discussion
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...
Found the issue. There is unprintable characters in the cell. Once fixed, everything is fine. Thanks for everyone help!
Vicky_Song
Impactful Individual
Impactful Individual