Tag Archives: consolidate

  • Combine or Append Data: Optimal Combination Pattern

    image

    This is going to be the last post series in the series on Combine or Append Data.

    In the first post we saw the basics of how to do the Append operation through the UI.

    In the second post we saw the Combine Files experience with Flat Files and how easy it is to combine as many files as you want.

    In the third post we had a contrast of the Combine Files experience using Excel Workbooks instead of simple flat files and what things we needed to consider this time that we didn’t consider with simple flat files.

    In this fourth and last post we’ll be going back to the basics using the function that we discovered in the first post – Table.Combine which is the most optimal function for combining / appending data.

  • Combine or Append Data: Combining Excel Files

    image

    In the previous post we saw how we were able to combine multiple files from a Folder.

    In that post we were using flat files but, how would that process be for Excel files?

    This is the post where we’re going to see the difference between simple flat files and more complex files (like an Excel workbook) when it comes to using the Combine Files experience inside of Power BI / Power Query.

  • Combine or Append Data: Combining Flat Files

    Combine Flat FIles from Folder

    In the previous blog post, I went through the basic concepts behind the Append operation found in Power Query for Excel and Power BI.

    In that post, we only used 2 files and it was pretty straightforward to simply click the Append queries button to combine both queries like so:

    A more complex scenario

    but what happens when you have multiple files? Let’s say 12 files. 1 for each month of the year.