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 didn't work.
Also, as you can see in the picture, the "Total" column looks completely clean.
I'll be happy if you can help me.
6 Replies
- adudani
Memorable Member
Anonymous ,
seems like this might be in other queries ( Vendor/ DimPersonnel / Kapsam..).
If you close and apply, a query with the row number and error table along with it's columns show up.Once the row/column is identified, left-click on the error and it should show what charecters are causing this which could then be replaced.
Appreciate a thumbs up if this is helpful.
- adudani
This 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
- mussaenda
Community Champion
Hi Anonymous ,
It is possible that the error is not showing up because your dataset is only showing the first 1000 rows.
try to double click the message on lower left and select entire dataset.
Please let me know if this helps.
Thanks
