Data not showing up month over month

[Anonymous]

I have a report that shows package logging results from SQL Server tables.  I want it to be up-to-the-minute accurate, so I'm using DirectQuery.  I'm using a "recent dates" view to filter the data to only "this month and last month".  It works great, but when the month rolls over, I get no records in the table from the new month, until I "Edit in PowerBI Desktop", refresh the local copy, and re-upload the report.  To compound the annoyance, once I do this refresh (which can't be automated because it's DirectQuery), I don't see data from the previous month any longer.

Here's what it looks like today, before I refresh it:

No data from this month showingData from last month is still there

And after I refresh in PowerBI Desktop:

Data from last month no longer shows up

Any ideas what's going on here, or how to fix it?