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
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