If your table isn't very huge you could use a where-clause within a Preceding Load like:
where Date = date(today()-1) or
Date = date(floor(weekstart(today())-1) or
Date = date(floor(monthstart(today())-1);
SQL SELECT *
FROM 'abc.DBO.'XYZ' ;
I think the same main-logic (with other functions and probably more efforts) could be applied to the sql-statement when the sql-load is too heavy without filtering.