SHARE

Import Multiple CSV Files In 1 Step & Retrieve New Files Automatically

See how to import multiple CSV files from a folder and refresh Query and PivotTable when new files are in folder:

  • 1. Problem Setup
  • 2. Power Query Import From Folder
  • 3. Edit Query and look at code that is written
  • 4. Build PivotTable with Slicer
  • 5. Add New Files to Folder
  • 6. Automatically update with Refresh

Download Video from here

powerquery-video-button

Download Sample DataSet for Practice from here

owerquery-sample-dataset-button

themiscellaneousblog
READ  PowerQuery: 1# Merge 3 Tables Into One in PowerPivot or Excel Table