Need to append data from a new table into an existing table

[MikeGeno]

Hello,

My data tab has exceeded one sheet in excel.  I have been importing the data to a table named Sales.  In the BI model, this table has a number of columns at the end that are not in the datasource that run various conversions.   

I added a new tab to my excel file named Dec24 which contains identical columns.

All my visuals are built to run off the Sales table.  How can I add the Dec24 data to the existing Sales table?  When I do an append query it creates a new table.  I am hoping to avoid updating all of the visuals to point to the new table.

Thanks in advance.

[MikeGeno]

Thank you @jdbuchanan71 !  Appreciate the help.

[jdbuchanan71 · Accepted solution]

@MikeGeno 

In your model, you can add a connection to the new tab.  This will not get loaded, it is just a conneciton to the new tab.  You do this by turning off 'Enable Load'

Make sure your new data is structure the same as your existing data, same column names and data formats and the column names are case sensitive.

Then select your existing table and select Append Queries (not Append as new).

Pick your new data from the list and it should be added onto the bottom of your existing table.

When I do it this way table 2 is added to the bottom of table 1.