Forum Discussion
How to append data from another table upon refresh?
Hi I 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. E.g: Table1: Table 2: Once the ...
venal
Memorable Member
Memorable Member1. 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.