Forum Discussion

Orchestra2410's avatar
Orchestra2410
Copper Contributor
Nov 19, 2020

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...
excel
ExcelExciting's avatar
ExcelExciting
MVP
Nov 19, 2020

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.

Orchestra2410's avatar
Orchestra2410
Copper Contributor
Nov 19, 2020
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.
  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Nov 19, 2020

    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.

    • Orchestra2410's avatar
      Orchestra2410
      Copper Contributor
      Nov 19, 2020
      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.
      • ExcelExciting's avatar
        ExcelExciting
        MVP
        Nov 19, 2020

        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.

Resources