SOLVED
Home

Power Query Editor.

%3CLINGO-SUB%20id%3D%22lingo-sub-834461%22%20slang%3D%22en-US%22%3EPower%20Query%20Editor.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834461%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20First%20of%20all%2C%20I%20am%20new%20in%20this%20group-Somebody%20should%20welcome%20me!!!%20Otherwise%2C%20I'm%20seeking%20help%20on%20how%20to%20merge%2Fcombine%20over%203%20files%20in%20power%20query%20editor.%20Whenever%20I%20get%20to%20the%20%22get%20data%20from%20folder%22%20option%2C%20the%20first%20file%20automatically%20gets%20selected(or%20sometimes%20I%20only%20have%20one%20option%20to%20select%20of%20all%20the%203%20files)%2C%20making%20difficult%20to%20combine%20all%20the%20files.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%2C%20I%20need%20your%20help.%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-834461%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-834588%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20Editor.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834588%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F402595%22%20target%3D%22_blank%22%3E%40Benze_%3C%2FA%3EWelcome%20in%20this%20nuthouse!!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOnce%20you%20have%20the%20preview%20of%20the%20list%20of%20files%2C%20make%20sure%20you%20click%20%22Transform%20data%22.%20Then%20you%20should%20get%20a%20list%20of%20all%20files.%20Filter%20that%20list%20so%20you%20end%20up%20with%20exactly%20the%20files%20you%20want%20to%20combine.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-835946%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20Editor.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-835946%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much.%3C%2FLINGO-BODY%3E
Benze_
New Contributor

Hi all, First of all, I am new in this group-Somebody should welcome me!!! Otherwise, I'm seeking help on how to merge/combine over 3 files in power query editor. Whenever I get to the "get data from folder" option, the first file automatically gets selected(or sometimes I only have one option to select of all the 3 files), making difficult to combine all the files.

 

Please, I need your help.

Thanks.

2 Replies
Solution

@Benze_ Welcome in this nuthouse!!

 

Once you have the preview of the list of files, make sure you click "Transform data". Then you should get a list of all files. Filter that list so you end up with exactly the files you want to combine.

Thank you so much.
Related Conversations