Problem changing one data source for another identical one

I tried to eliminate the error by making an exact copy of the original Gsheet, changing the source to that one, and then adding the latest week's data.

The data source change works. After I add the new data and refresh, it's available on the table. However, I build two extra tables with that data. In one of them, I bring the data from the previous week's snapshot, filtering by snapshot date. On the other, I filter for currnet week's snapshot. When I go to these sub-tables, I don't see the latest week's data, which means that I can't update the model.

All measures are built in a third sub-table, which is a join of the previous week and current week's sub-tables.

I don't understand why the OG source table's data is not being picked up by the sub-tables. Could someone please explain?

Thank you!