Forum Discussion
Couldn't conver to number error
Hello everybody, I've been getting a we couldn't convert to error error for a few days now. Because the data is too big, I can't check it from excel. I tried remove empty and remove error but it d...
adudani
Memorable Member
Memorable MemberThis is the kind of message to look for:
While loading after close an apply ( in your example, find the previous table which is causing the error, should look like this)
if you click on View Errors
Row number and errors in table query will show
clicking on the error the values causing it will show
maybe this helps: How to deal with errors in Power Query (2 ways) - YouTube
Yes, I understand that just it doesn't showed up show the error box for me.