Forum Discussion
Combine Button Absent in Power Query
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.
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
Hi Orchestra2410,
No worries, just click the button pointing down, that will 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.
- 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.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.
