Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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...
Need Help
adudani's avatar
adudani
Icon for Memorable Member rankMemorable Member
3 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hey thanks for reply first of all, 

     

    I can't get a error table. It is the one of my problem

     

    How can i get it? 

     

    I try to close and apply and it doesn't showed up. . 

    • adudani's avatar
      adudani
      Icon for Memorable Member rankMemorable Member
      3 years ago

      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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Yes, I understand that just it doesn't showed up show the error box for me.