Forum Discussion
benglen
6 years agoFrequent Visitor
filter for first sheet in transform file parameter (connecting to excel files in a folder)
I'm attempting to connect to a folder of excel files in Power Query. I want it to pull the first sheet regardless of the sheet name. The query to load the data references the "Transform File . . " parameter as opposed to any specific sheet. I've seen demos where you can replace absolute sheet names with {0}, {1}, etc but I am not sure how that would work in this scenario:
The "Sheettest" is the first sheet in this example.
- Anonymous6 years ago
You want to replace "Sheet1_Sheet =" line with the line below:
Sheet1_Sheet = Table.SelectRows(Source,each [Kind] = "Sheet"){0}[Data],
1 Reply
- AnonymousNot applicable
You want to replace "Sheet1_Sheet =" line with the line below:
Sheet1_Sheet = Table.SelectRows(Source,each [Kind] = "Sheet"){0}[Data],