Advanced Editor Query - not all files pulling in

[cbtekrony]

I am trying to pull 2 files out of my folder below, but only one of them is pulling into BI. So, there must be something amiss with my language below. Any ideas?

let
Source = Folder.Files("C:\Users\cxxxy\OneDrive\Power BI\NewSalesC"),
filtered_for_xls = Table.SelectRows(Source, each Text.StartsWith([Extension], ".xls")),
added_exceldata = Table.AddColumn(filtered_for_xls, "ExcelData", each Excel.Workbook([Content])),
expanded_exceldata = Table.ExpandTableColumn(added_exceldata, "ExcelData", {"Name", "Data", "Kind"}, {"Name.1", "Data", "Kind"}),
filtered_for_datasheets = Table.SelectRows(expanded_exceldata, each ([Kind] = "Sheet") and ([Name.1] = "Data" )),
promoted_headers = Table.AddColumn(filtered_for_datasheets, "PromoteHeaders", each Table.PromoteHeaders([Data])),
Data1 = promoted_headers{0}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Data1, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Sales Period", type date}, {"Customer", type text}, {"TSV", type number}, {"Fee Type", type text}, {"State", type text}, {"Product Name", type text}, {"Product", type text}, {"Market", type text}, {"Appl/Use", type text}, {"Change Reason", type text}, {"Channel", type text}, {"Product Category", type text}, {"Platform", type text}, {"Sales Product Summary", type text}})
in
#"Changed Type"

[edhans · Accepted solution]

You clicked on a single Excel file. You need to use the Get Data from Folder (or SharePoint Folder) then click on the Combine button. It will generate a few new queries, custom functions, and folders and walk you through a wizard.

[cbtekrony]

@edhans Thanks. I had done some research and figured out the same. It was a little tough since I'm newer to queries. I didn't know there was a "Combine Files" function.

[edhans]

Great! Glad you got it sorted out.