Append table lost rows

[dgbraqe]

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 - 33866 rows. Colunm ChavePedido (33866 distinct values)
Base 2 - 76326 rows. Colunm ChavePedido (76326 distinct values)
Base Append - 110192 rows. Colunm ChavePedido (110107 distinct values)

The result in the Append base should be 110192 distinct lines, mirroring base 1 and base 2. How to make Append correct?

[v-yuezhe-msft]

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

@v-yuezhe-msft,

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