How to append data from another table upon refresh?

Question

HiI want to append a table data with other table, where table one is refreshed with new data. So how can i append the final table with a refresh.&nbsp;E.g: Table1:&nbsp;Table 2:&nbsp;Once the table 2 is updated upon refresh, Table 1 should be appended with table 2 data as below:&nbsp;I tried with Append Queries and try to remove 'Inclue in report refresh' option in query editor on the table1, but it didn't help.&nbsp;Can you suggest what is the best way to append these two tables upon refresh?&nbsp;Thanks&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

imkef · Answer

Without a Premium capacity where you could use the incremental load feature, there is no native way in Power BI to achieve this.
Best workaround is probably to use an R- or Python-script to export the imported data to a csv-file like described here:&nbsp;https://www.thebiccountant.com/2016/02/09/how-to-create-a-load-history-or-load-log-in-power-query-or-power-bi/&nbsp;
&nbsp;

venal · Answer

For table2 - disable the "Enable Load" in Edit Queries and enable the "Include in report refresh".

venal · Answer

1. Table12. Table23. Home &gt;&gt; Edit Queries &gt;&gt; Edit Queries &gt;&gt; Append Queries4. Append Queries Screen &gt;&gt; Two Tables (Enable the radio button) &gt;&gt; Table to append &gt;&gt; select "Table2" &gt;&gt; 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.&nbsp;Hope it will help you to resolve your query.

anonymous · Answer

Hi venal&nbsp;,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).&nbsp;&nbsp;How can I make this workable?&nbsp;This is my changes done as you suggested:Table 2: with latest data as per date.&nbsp;Table 1: Table which needs to be appended with Table 2. This has data for previous dates.&nbsp;&nbsp;&nbsp;Let me know if I missed anything?&nbsp;The table 1 has to be appended, but it seems to be replacing the data from table 2.&nbsp;Regards&nbsp;&nbsp;&nbsp;