Append Query not bringing in all data

I am having an issue appending queries as well. I have 4 queries, each representing a calendar quarter, so Q1, Q2, Q3, Q4 of 2023. Each query contains identical columns: ticket number, open date, location, etc.

I can append 3 queries, no problem, but the 4th query does not bring in the "open date" data. I have tried numerous methods to append the queries. 

1. Get data from each query individually and then try to append as new. I have also tried to do a simple append (not as new). Same problem.
   1. Each individual query shows up correctly. Only when I append them do I lose the "open date" data in the Q4 query.
   2. I have loaded all the queries before attempting to append.
   3. These are all connections in the same data model, but I have also loaded them as tables and then tried to append the tables in PowerQuery Editor and I have the same issue, except that sometimes the "open date" data from the other tables do not show data.
2. Get Data from Folder and append as new.
   1. In this scenario, Q4 data is the only one that does not show up for some reason.
   2. The preview of the data looks good, but once in PQ Editor to transform data, "open date" data is lost.
3. Copy and Paste only selected tables into new files (just to eliminate the possibility of hidden worksheets causing issues), but have the same problem.
4. I have ensured that the column types are all the same.
5. I should add that, the unusual part is that if Q4 date data is brought in, then Q1-Q3 dates are not brought in. If Q1-Q3 date data is properly brought in, then Q4 data is missing. I have double-checked the data in Q4 compared to the others and I do not see any obvious issues.

Any ideas on what's happening?