Forum Discussion
Expression.Error: We cannot convert the value 1110011 to type Text.
We have a daily report that we run with no issues. Today we received the "Expression.Error: We cannot convert the value 1110011 to type Text." message and it doesn't make sense. The source spreadshee...
At the bottom, you will be able to see column profiling based on Top 1000 rows. Click it and change it to entire data set.
Now, go to View menu and check column quality box. See if any column (not necessarily this column) is showing Error.
If yes, go to Home menu - Keep rows - Keep errors
Then you will be able to analyze error.
Thank you for the response. I did not know about that feature so that was good to know.
However, strangely enough, every column shows Valid 100%. When I select "Keep Errors", I still get the Expression.Error: We cannot convert the value 1110011 to type Text. message.
Create a duplicate query and before the final step, Home, remove rows, remove blank rows and then see what final step is giving.
Same error message
