Combining data from multiple worksheets on import

%3CLINGO-SUB%20id%3D%22lingo-sub-1767559%22%20slang%3D%22en-US%22%3ECombining%20data%20from%20multiple%20worksheets%20on%20import%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1767559%22%20slang%3D%22en-US%22%3E%3CP%3EOnly%20one%20of%20multiple%20sheets%20appear%20during%20the%20%22Import%20from%20folders%22%20option%20from%20the%20data%20tab.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1767559%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1767897%22%20slang%3D%22en-US%22%3ERe%3A%20Combining%20data%20from%20multiple%20worksheets%20on%20import%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1767897%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F827430%22%20target%3D%22_blank%22%3E%40MS_Teck8932%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20mean%20From%20Folder%20connector%20in%20Power%20Query%3F%20Yes%2C%20here%20you%20select%20only%20one%2C%20apply%20some%20transformation%20to%20it%20and%20all%20the%20rest%20will%20be%20transformed%20the%20same%20way%2C%20result%20is%20combined.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Only one of multiple sheets appear during the "Import from folders" option from the data tab.

 

1 Reply
Highlighted

@MS_Teck8932 

Do you mean From Folder connector in Power Query? Yes, here you select only one, apply some transformation to it and all the rest will be transformed the same way, result is combined.