Forum Discussion

dgbraqe's avatar
dgbraqe
Frequent Visitor
8 years ago
Solved

Append table lost rows

Hi, I'm having a problem loading two queries from different bases and merging them using the "Append as new" option. The resulting table is joining records incorrectly, following examples:   Base 1...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

dgbraqe,

Do you have duplicated values in ChavePedido column of Base 1 and Base 2 tables? For example, value A exists both in Base 1 and Base 2.

Based on your third screenshot, there are 110192 rows in the append table, which is correct. But for the  Colunm ChavePedido, there are 110107 distinct values.

Regards,
Lydia

  • dgbraqe's avatar
    dgbraqe
    Frequent Visitor
    8 years ago

    No, I do not have duplicate ChavePedido values. This field is unique in each database, to ensure that after joining the bases do not match, I use a "source" numbering to do the composition of this key. Still to make sure they do not duplicate, I also exported the data from each database to Excel and checked duplicity.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      dgbraqe,

      What version of Power BI Desktop do you use? Is there any possibility that you can share us the sample data of your tables?

      Regards,
      Lydia

      • dgbraqe's avatar
        dgbraqe
        Frequent Visitor
        8 years ago

        Anonymous,

         

        I'm using the latest version, yesterday I upgraded to the June version.

        I have prepared an example, I will share the Power BI file. Example Append
        Some considerations:
        - The records of each base are obtained through views.
        - I noticed that with each update of the records, the result in Append was different (sometimes they were correct and sometimes incorrect).

         

        Regards,

        Braque