Forum Discussion
How to append data from another table upon refresh?
1. Table1
2. Table2
3. Home >> Edit Queries >> Edit Queries >> Append Queries
4. Append Queries Screen >> Two Tables (Enable the radio button) >> Table to append >> select "Table2" >> Click on "Ok".
5. Once it's done, right click on the table2 and disable the "Enable Load" and enable the "Include in report refresh".
6. So that you will get the latest data in Power Bi.
7. If you enable the "Enable Load" for table2, it will load into the data model and it will display in the "Data View and Report View".
8. As both tables data are appended into Table1, better to disable the "Enable load" to avoid the performance issues.
Hope it will help you to resolve your query.
Hi venal ,
Sorry for coming back late. But I think this doesn't seem to update the data from previous and append it. I could still see that table is just refreshed with new data (new date).
How can I make this workable?
This is my changes done as you suggested:
Table 2: with latest data as per date.
Table 1: Table which needs to be appended with Table 2. This has data for previous dates.
Let me know if I missed anything?
The table 1 has to be appended, but it seems to be replacing the data from table 2.
Regards
Please refer the below link to download the PBIX file.
http://www.mediafire.com/file/qit6pvhvitpja3x/nchawda-append.pbix/file
If this post was helpful may I ask you to mark it as solution and give it some kudos?
Hi venal
It doesn't work. Every time the table 2 is replaced with new data and that data has to be appended to table 1. But here it happens that everytime the table 2 is replaced with new data for each day, the same data is being replaced in the table 1.
How can I make sure that data from table 1 is retained for previous dates?
Thanks