Forum Discussion

ThomasWeppler's avatar
ThomasWeppler
Impactful Individual
2 years ago
Solved

The appended query function adds a row twice

Hi power bi community

I use this function and add a row twice. Can anyone explain to me what I might be doing wrong?
All help will be greatly appriciated.

  • Wrote the code again duplicated it and that solved the problem, so I am pretty sure this one was on me

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    ThomasWeppler Are you certain the row doesn't appear in both original tables? Not a lot to go on with this one in terms of details so nearly impossible to know. There's not a lot to go wrong with Table.Combine({Table1, Table2})

    • ThomasWeppler's avatar
      ThomasWeppler
      Impactful Individual

      Yes I am certain. It seemed to happen when I copied a colum that wasn't in all the tables. The most likely situation is that I just made a mistake somewhere so I think that I will just leave it be unless I see it again.

  • ThomasWeppler's avatar
    ThomasWeppler
    Impactful Individual

    Wrote the code again duplicated it and that solved the problem, so I am pretty sure this one was on me