Monthly Data Updates

[Gene2020]

Hope to keep this simple.   I load 3 tables daily, one shows only current month data, one shows current year monthly data except for current month and one shows historical data for previous years.  My issue is that on the first of the month I cannot refresh the data because the current month contains no data and I get the "Key doesn't match" error.  On the 2nd day of the month everything will work fine but the first of every month is an issue.  The only way I know of solving this is to delete that table on the 1st of each month then add it back on the 2nd but then I have to re-establish the relationships etc.  Any way to over come this issue?

[v-janeyg-msft]

Hi, @Gene2020 

Do you filter the data using this method in power query? You can try it.

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _Janey

[Gene2020]

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?  

[v-janeyg-msft]

Hi, @Gene2020 

Are you using import mode to connect the data?

If yes, You can create a table with the same column as the source table, fill in the 1st of all months in the date column, and the other contents are empty, then append the table with the source table.

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _Janey