See how to use Import 10 Text Files and Append (combine) then into a single Proper Data Set before making a PivotTable Report. Compare and Contrast whether we should use Connection Only or Data Model to store the data.
(00:18) Introduction & Look at Text Files that Contain 7 Million Transactional Records
(01:43) Power Query (Get & Transform) Import From Folder to append (combine) 10 Text Files that contain 7 Millions transactional records.
(05:07) Load Data as Connection Only and Make PivotTable
(08:17) Load Data into Data Model and Make PivotTable.