Forum Discussion
Append Refresh issue
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 |
4 Replies
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
Hi - I did it in edit query.
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
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
