Error on Data Load - OLE DB or ODBC error: [DataSource.Error] Date-aggregate functions...

I was able to get it to work, but the solution was a bit painful, and it really isn't a solution. I copied each Power Query script over to a new Power BI file, one by one, except for a few that I didn't need. When all was said and done, the new file, which has the exact same Power Query load statements (since I copied/pasted) worked, but the old file won't. Just to be certain it wasn't one of the other tables I didn't need and bring over, I deleted them from the original. It still didn't work.

I have no idea what the issue is in the original file.