Forum Discussion

Rafaelpalma's avatar
Rafaelpalma
Frequent Visitor
4 years ago

Add query repeating records

Good evening!
I have a report where I use the function "add new queries" (I join tables/base that have the same columns and headers). I noticed that the append is duplicating the table records. For example, the total should be 700 records (adding all tables/bases that contemplate the scope), however, 4000 records are appearing. I went to analyze and saw that they had the same duplicate records.
Does anyone know why this happened? and how do I fix?

Need Help

1 Reply

  • KNP's avatar
    KNP
    Super User
    4 years ago

    Hi Rafaelpalma, 

     

    Can you share your Power Query code (remove any sensitive info)?

    It will make it easier for us to figure out what is going on.