Import Multi Xlsm files From Folder Into One PowerPivot, but the count of some files is double the original File.|Power Query|Excel Forum|My Online Training Hub

Hello friends, Hope all is Well & Safe! Please bear with me & please help me because I am losing my mind.

I am (via PowerQuery) combining Xlsm files, but the count of rows of some files that appears on PowerPivot are double the number of rows of the original file, why the # of rows of some are matching the row count, and others not.

Let me please give you the steps that I am taking.

1. IT Provides me with CSV files, e.g. LA Jan-20 (8,000 rows), LA Feb-20 (3,000 rows), LA Mar-20 (5,000 rows), LA Apr-20 (2,000 rows).
2. I save each workbook as Xlsm, and place all the workbooks in one folder (Proc DB).
3. Apply the steps of Power Query: Import Multiple Excel Files From Folder Into One Data Model 
4. Run a PowerPivot based on the data model, and count the rows based on the combing of PowerQuery.
5. PowerPivot gives these counts: LA Jan-20 (8,000 rows), LA Feb-20 (6,000 rows), LA Mar-20 (5,000 rows), LA Apr-20 (2,000 rows
6. You can see that Feb-20 is showing double the row count; should've been 3,000, but instead got 6,000.

Why the counting was identical with some of the original workbooks, and not with the others? Please remember every file and its contents are unique, i.e. doesn't have duplications (City Month-Year).

Your kind Help is truly appreciated & needed to fix this headache.

All the Best,