Merging several workbooks in power BI

[jutu]

Hi. I have 16 workbooks with the same structure and type of data. I have tried all combinations to add them but I am not being successful. From get data I go to folder and then combine and transform. I think that what I am perhaps doing wrong is the combined files screen which I have also attached as a shot screen for clarity. I always end without the order and shipping dates columns. Them both are missing no matter what I try. I tried different combinations like choosing the top file rather than the "First File" option too as seen in a youtube video. I realise from the several videos that I have watched that this is not an easy one to answer so thank you very much in advance.

Also, is there a way in Power BI to just load several workbooks without consolidating them?

 

[AlanSidman]

Attached I have Appended each file and all columns seem to be in order.

 

[p45cal]

Alan, I see no attachment.

 

[AlanSidman]

Thanks P for pointing that out. It appears that the file was too big even when zipped. Didn't realize that it did not post. Have linked the file to Box.net. Here is the link to grab the file. https://app.box.com/s/w7oyqjd3cajl4ur812fszgjbh8r9kc4g

 

[jutu]

Hi. I have now resolved it and was quite easy really in the end but thank you for your time.
Alan, if they were too big why I can see it was sent? Thank you

 

[AlanSidman]

@jutu
It was too large to attach to this forum, therefore, I posted it to Box.net where you were able to retrieve.