• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Merging several workbooks in power BI

jutu

Member
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?
 

Attachments

  • 2014-11 sales history.xlsx
    231.1 KB · Views: 3
  • 2015-01 sales history.xlsx
    136.9 KB · Views: 2
  • 2014-12 sales history.xlsx
    233.7 KB · Views: 2
  • 2015-10 sales history.xlsx
    274.1 KB · Views: 2
  • Combiend worksheets screenshoot.doc
    41.5 KB · Views: 1
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
 
Back
Top