sharepoint folder query not syncing all text files

Thank you for your reply v-jiascu-msft.

I did filter rows but the text files missing should not be affected by it.

I also just refreshed the dataset and it is still not showing.

Is there a limit to the number of rows? I am running on the free PBI version.

Here is my complete code from the Advanced Editor.

let
Source = SharePoint.Files("https://mysite", [ApiVersion = 15]),
#"Filtered Rows - Online Folder" = Table.SelectRows(Source, each Text.EndsWith([Folder Path], "DataSources/KBT/") and not Text.Contains([Name], "WarningsFile")),
#"Sorted Rows" = Table.Sort(#"Filtered Rows - Online Folder",{{"Name", Order.Descending}}),
#"Removed Columns" = Table.RemoveColumns(#"Sorted Rows",{"Name", "Extension", "Date accessed", "Date created", "Attributes", "Folder Path"}),
#"Filtered Hidden Files1" = Table.SelectRows(#"Removed Columns", each [Attributes]?[Hidden]? <> true),
#"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File from KBT Logs - Logs OD4B 2", each #"Transform File from KBT Logs - Logs OD4B 2"([Content])),
#"Removed Other Columns1" = Table.SelectColumns(#"Invoke Custom Function1",{"Date modified", "Transform File from KBT Logs - Logs OD4B 2"}),
#"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File from KBT Logs - Logs OD4B 2", Table.ColumnNames(#"Transform File from KBT Logs - Logs OD4B 2"(#"Sample File (3)"))),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1",{{"Column1", type text}}),
#"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Column1", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, false), {"Column1.1", "Column1.2"}),
#"Sorted Rows1" = Table.Sort(#"Split Column by Delimiter",{{"Column1.2", Order.Ascending}}),
#"Split Column by Delimiter1" = Table.SplitColumn(#"Sorted Rows1", "Column1.2", Splitter.SplitTextByAnyDelimiter({"\\", "C:", "D:", "L:\", "X:\"}, QuoteStyle.Csv, false), {"Column1.2.1", "Column1.2.2"}),
#"Changed Type2" = Table.TransformColumnTypes(#"Split Column by Delimiter1",{{"Column1.2.1", type text}, {"Column1.2.2", type text}}),
#"Split Column by Delimiter2" = Table.SplitColumn(#"Changed Type2", "Column1.2.2", Splitter.SplitTextByEachDelimiter({"\"}, QuoteStyle.Csv, true), {"Column1.2.2.1", "Column1.2.2.2"}),
#"Changed Type3" = Table.TransformColumnTypes(#"Split Column by Delimiter2",{{"Column1.2.2.1", type text}, {"Column1.2.2.2", type text}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type3",{{"Column1.2.1", "WindowName"}, {"Column1.1", "Username"}, {"Column1.2.2.1", "FilePath"}, {"Column1.2.2.2", "FileName"}}),
#"Duplicated Column - FileName" = Table.DuplicateColumn(#"Renamed Columns", "FileName", "FileName - Copy"),
#"Extracted Last Characters - File type" = Table.TransformColumns(#"Duplicated Column - FileName", {{"FileName - Copy", each Text.End(_, 3), type text}}),
#"Renamed Columns1" = Table.RenameColumns(#"Extracted Last Characters - File type",{{"FileName - Copy", "File type"}, {"FilePath", "File path"}, {"FileName", "File name"}}),
#"Extracted Date" = Table.TransformColumns(#"Renamed Columns1",{{"Date modified", DateTime.Date, type date}}),
#"Sorted Rows - Date Modified" = Table.Sort(#"Extracted Date",{{"Date modified", Order.Descending}})
in
#"Sorted Rows - Date Modified"