Merge 3 Tables Into One in PowerPivot or Excel Table

See how to import three tables from three different source files (Access database, Excel File, Text File) and merge them into one table using Power Query. Merge tables into the PowerPivot Data Model or an Excel Table

  • 1. Import Access File. Remove column, Format Data Type as Date
  • 2. Import Excel File
  • 3. Import Text File
  • 4. Append Table: merge Three Tables
  • 5. Load to Data Model or Excel Table

Download Video from here


Download Sample DataSet for Practice from here



READ  PowerQuery 3# Import Multiple CSV Files In 1 Step & Retrieve New Files Automatically