Combine Button Absent in Power Query

%3CLINGO-SUB%20id%3D%22lingo-sub-1906125%22%20slang%3D%22en-US%22%3ECombine%20Button%20Absent%20in%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1906125%22%20slang%3D%22en-US%22%3EHello%20experts.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20a%20problem%20with%20my%20power%20query.%20When%20I%20try%20to%20combine%20files%20by%20folder%2C%20the%20resulting%20power%20query%20preview%20window%20does%20not%20include%20the%20%22combine%22%20button%20at%20the%20bottom.%20Now%20I%20don't%20know%20how%20to%20proceed%20for%20the%20steps%20I%20was%20taught%20requires%20me%20to%20click%20on%20the%20%22combine%20and%20transform%22%20button.%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20can%20anybody%20help%20neon%20how%20to%20fix%20this%3F%20I%20use%20Excel%202016%2C%20and%20this%20has%20been%20troubling%20me%20for%20days%20and%20days.%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20find%20attached%20a%20snapshot%20of%20the%20power%20query%20window%20that%20loads%20when%20I%20try%20to%20combine%20files%20in%20a%20single%20folder.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1906125%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1906195%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20Button%20Absent%20in%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1906195%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F874418%22%20target%3D%22_blank%22%3E%40Orchestra2410%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENo%20worries%2C%20just%20click%20the%20button%20pointing%20down%2C%20that%20will%20combine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Snag_b29cc8e.png%22%20style%3D%22width%3A%20518px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F234663iD715C402E031946B%2Fimage-dimensions%2F518x264%3Fv%3D1.0%22%20width%3D%22518%22%20height%3D%22264%22%20role%3D%22button%22%20title%3D%22Snag_b29cc8e.png%22%20alt%3D%22Snag_b29cc8e.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%20%26amp%3B%20like%20it%20to%20help%20the%20other%20members%20find%20it%20more.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1906279%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20Button%20Absent%20in%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1906279%22%20slang%3D%22en-US%22%3EThanks%20Faraz%20Shaikh.%20But%20upon%20clicking%20this%2C%20I%20get%20a%20DataFormat.Error%20response.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20attaching%20a%20snapshot%20below.%20How%20do%20I%20proceed%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20help.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1906435%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20Button%20Absent%20in%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1906435%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F874418%22%20target%3D%22_blank%22%3E%40Orchestra2410%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20please%20attach%20the%20sample%20file%20removing%20the%20sensitive%20information%20%26amp%3B%20also%20the%20file%20with%20the%20error%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%20%26amp%3B%20like%20it%20to%20help%20the%20other%20members%20find%20it%20more.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1906495%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20Button%20Absent%20in%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1906495%22%20slang%3D%22en-US%22%3EHello%20Faraz%20Shaikh%2C%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20find%20attached%20the%20files%20I%20am%20trying%20to%20combine.%20These%20files%20were%20in%20the%20same%20folder%2C%20so%20I%20was%20trying%20to%20combine%20them%20%22By%20Folder%22.%20They%20are%20just%20fictitious%20data%20developed%20for%20my%20Excel%20class.%20Other%20people%20in%20my%20class%20were%20able%20to%20combine%20these%2C%20but%20I%20just%20cannot%20find%20the%20combine%20button%20in%20my%20own%20Excel.%20I%20don't%20know%20if%20it%20has%20anything%20to%20do%20with%20the%20installation%20process%20of%20my%20Excel...%3CBR%20%2F%3E%3CBR%20%2F%3EI%20do%20not%20know%20what%20you%20mean%20by%20%22the%20file%20with%20the%20error%22%2C%20so%20I%20really%20do%20not%20know%20what%20I%20am%20supposed%20to%20attach%20regarding%20that.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20again%20for%20your%20kind%20assistance.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1906818%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20Button%20Absent%20in%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1906818%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F874418%22%20target%3D%22_blank%22%3E%40Orchestra2410%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20attachment%2C%20I%20check%20at%20my%20end%20there%20is%20no%20issue%20when%20I%20tried%20combining%20the%20fie.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22file%20with%20the%20error%22%20I%20mean%20is%20the%20query%20file%20which%20you%20are%20trying%20to%20combine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%20%26amp%3B%20like%20it%20to%20help%20the%20other%20members%20find%20it%20more.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
Hello experts.

I have a problem with my power query. When I try to combine files by folder, the resulting power query preview window does not include the "combine" button at the bottom. Now I don't know how to proceed for the steps I was taught requires me to click on the "combine and transform" button.

Please can anybody help neon how to fix this? I use Excel 2016, and this has been troubling me for days and days.

Please find attached a snapshot of the power query window that loads when I try to combine files in a single folder.
5 Replies
Highlighted

Hi @Orchestra2410,

 

No worries, just click the button pointing down, that will combine.

 

Snag_b29cc8e.png

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

Highlighted
Thanks Faraz Shaikh. But upon clicking this, I get a DataFormat.Error response.

I am attaching a snapshot below. How do I proceed?

Thank you for your help.
Highlighted

Hi @Orchestra2410 

 

Could you please attach the sample file removing the sensitive information & also the file with the error

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

Highlighted
Hello Faraz Shaikh,

Please find attached the files I am trying to combine. These files were in the same folder, so I was trying to combine them "By Folder". They are just fictitious data developed for my Excel class. Other people in my class were able to combine these, but I just cannot find the combine button in my own Excel. I don't know if it has anything to do with the installation process of my Excel...

I do not know what you mean by "the file with the error", so I really do not know what I am supposed to attach regarding that.

Thanks again for your kind assistance.
Highlighted

Hi @Orchestra2410

 

Thanks for the attachment, I check at my end there is no issue when I tried combining the fie.

 

"file with the error" I mean is the query file which you are trying to combine.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.