Append Query not bringing in all data

Hi Nick,

Yes, I have checked that. In fact Query 2 and 3 are a copy of Query 1. The only difference is the parameter value for the data source for the date range of data. Other than that, they are identical in every way. 

If I view the data of any single query using that query source, then everything is exactly right. It's only when bringing all 3 together that I see the issue.

I checked the table view row values for each query, and see that hundreds of thousands of records are missing. 

If you use R there is another way to append using R.

R can be used to Append multiple tables. However, R can append tables when they have same Column Names and same number of Columns (as far as I know).

Power BI Append can append tables with dissimilar number of columns and dissimilar column names.

Example - tbl_A appended with tbl_B

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("VczBDQAhCATAXngTI4voWYuh/zbkDh9ewmOT2WUtqlbiUKUTE5S72Bsaj2HkHIX2L9hz/LBeXJP0EO4leEqyyMeYJX5frMlo5L4B", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Date " = _t, Price1 = _t, Price2 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date ", type text}, {"Price1", type number}, {"Price2", type number}})
in
    #"Changed Type"

tbl_A

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("bcuxDcAwCETRXaiRBUewnVks9l/DJDSxlOqKd38tEjTpDaKdmPRm81yAJwWn6qFFeXnM0vynHFosX3Z+VXlWjHHGl1XsoIgN", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Date " = _t, Price1 = _t, Price2 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date ", type text}, {"Price1", type number}, {"Price2", type number}}),
    #"Run R script" = R.Execute("# 'dataset' holds the input data for this script#(lf)df_B <- dataset#(lf)df_A <- dataset2#(lf)df_temp <- rbind(df_A, df_B)#(lf)#(lf)output <- df_temp",[dataset=#"Changed Type", dataset2=tbl_A]),
    output = #"Run R script"{[Name="output"]}[Value]
in
    output

tbl_B

I did not provide sample data, but I provided information on the data, if that might help.

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?