I'm not sure why this isn't working. I have a DataEntry table and a Data table. It would be great to edit the DataEntry Table by adding a row of data (or multiple rows) then having that data added to the DataTable. For some reason the old data is deleted in the Data table and it is replaced with the new data from DataEntrytbl every time it is updated.
So far I have:
1. DataEntryTbl > Get Data from Table/Range > Create Connection
2. DataTbl > Get Data from Table/Range > Create Connection
3. Append Queries
Help, this is confusing.
Think of it this way.
DataTbl is your very first empty table. You append the DataEntryTbl table and load it back to Excel. That table is now called DataTbl_1. I marked it in green to make it clear that this is a PQ generated table. And this last one should be the starting point for your next update, not DataTbl. Obviously, when you do the next update based on the empty DataTbl, the previous update is no longer there.
So, I changed the query that appends new entries to point the Source to DataTbl_1. The query thus references its own previous output table. You need to do it manually and go into the M-code to change it.
I agree that this isn't very intuitive, but you will get used to the principle. Google for "self referencing queries Power Query" and you'll find plenty of resources describing what you can do with this trick.
See attached!
