Forum Discussion

PGAT's avatar
PGAT
Helper III
6 years ago

Error (row index 1)

  Hi all, for a while now, the PBI has been working well for me until today. I suspect I may have deleted a step, and now I cannot figure out what went wrong.  I look up the error but I don't unders...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

PGAT , Have you created an index column and used it in some other column and deleted it , reverse the deleted step(remove it), or add it again

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    PGAT update your line as below, it is a missing last parameter:

     

    #"Added Index" = Table.AddIndexColumn(Source, "Row Number" ,1, 1),

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    • PGAT's avatar
      PGAT
      Helper III
      6 years ago

      Hi there, thanks, what do you mean by missing last parameter?  

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        #"Added Index" = Table.AddIndexColumn(Source, "Row Number" ,1, 1)

         

        You are missing last parameter ,1 in above M code.

  • PGAT's avatar
    PGAT
    Helper III
    6 years ago

    Hi Amitchandak, thanks, oh no... I am really not sure. All the steps look so right.  Oh man...