Combine worksheets only extracts data from one worksheet

[drluke]

I am trying to combine 2 worksheets from 2 different files using power query (I'm using the 2016 Get & Transform version) but only the worksheet from the first file is extracted. The combine process ignores the other file completely. I have followed the steps described in the Microsoft help pages, but no success.

Is there a website or reference that simply and clearly explains what to do to get the desired result?

 

[Matt Allington]

I have written many articles in he topic. https://exceleratorbi.com.au/?s=Combine

I suggest you check hat the sheet name is the same in both workbooks. It matters.

 

[drluke]

I have written many articles in he topic. https://exceleratorbi.com.au/?s=Combine

I suggest you check hat the sheet name is the same in both workbooks. It matters.

Thank you this has helped a lot!