Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I've a table whereby there were different text values and numeric values in the same column.
I tried to uncheck the text value box in Power Query and load the file, below error message pop-up. Please help.
Besides, kindly also advice if there is any method or formula to uncheck different text value box in one click.
Thanks.
Regards,
LC
Solved! Go to Solution.
Hi @Tan_LC
First transform this column to Number data type (decimal or whole number per your need), then remove rows which have errors.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @Tan_LC
First transform this column to Number data type (decimal or whole number per your need), then remove rows which have errors.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.