Append Refresh issue

[Gururajv007]

Dear Expert - Need help from you.

Table 1			Table 2			Combined Table
Customer	ID		Customer	ID		Customer	ID
Just	1		Rock	11		Just	1
Imagine	2		Mick	12		Imagine	2
Test	3		fly	13		Test	3
						Rock	11
						Mick	12
						fly	13

Issue : When I refresh the Table 1 and Table 2  like below, I will see still old customer id's in the combined table. Can you please let me know how to fix the issue.

Output should be below Combined table But I am still getting ( Imagine,2 ) also which is not in table 1 and table 2 when I refresh the tables.

Table 1			Table 2			Combined Table
Customer	ID		Customer	ID		Customer	ID
Just	1		Rock	11		Just	1
Test	3		Mick	12		Test	3
Guru	6		fly	13		Guru	6
Raj	7		Jack	113		Raj	7
						Rock	11
						Mick	12
						fly	13
						Jack	113

[v-lili6-msft]

hi  @Gururajv007 

what is  ( Imagine,2 )? If you operate it correctly, the issue should not arise.

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

and you should know that in edit queries(power query) each table will only preview show 1000 rows of data, so please check it in power bi data view to see the complete data

Regards,

Lin

[Pragati11]

Hi @Gururajv007 ,

Not sure on how you are appending data. You should usee "Append Queries" option on Table1 & Table2 in Edit Query.

The issue should not arise.

Remember the column names in Table1 & Table2 should be exactly same.

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[amitchandak]

@Gururajv007 , how you have appended it

In edit query

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Or in Dax

union(A,B)

In both case after refresh only new Id should come in combined table

[Gururajv007]

Hi - I did it in edit query.