Monthly Data Updates

v-janeyg-msft,

Thanks for your reply however it has nothing to do with filters, or anything in the query/report function.  The problem is the source table doesn't exist for the first day of the month.  The table itself is not there because the source has no data until the 2nd day of the month so it is not created until the 2nd day of the month.  The table only contains rows where there is actual data and since the first day of the month has not "finished" the table isn't created.   Everything works fine as soon as the table is created.  My issue is that for my needs I have to combine the missing table along with historical data tables to create the "sales" table to do my reports.  Since the table is missing on the 1st of the month the query fails because it cannot append to something that doesn't exist.   My question should be is there a way to create a "dummy" table on the 1st of the month to trick the query into loading all the tables that actually do exist?