Question regarding Data Transformation Not Recognizing ALL Data

[tmac1954]

I created a report that is connected to a folder with excel files.  It originally contained 2017-2024 and I added 2015-2016 and this is where my issue popped up.  Excel files 2015, 2016 was missing 3 columns the other years had.  I did insert the same columns in the 2015,2016 file but it has no data (none available).  The power query sample file is based on 2015 (with missing data) and does not recognize the data in the years 2017-2024.  How do I correct this?  Thank you for any feedback!

Files:

2015 (no data in 3 columns)

2016 (no data in 3 columns)

2017 (all data)  

2018 (all data)

2019 (all data)

2020 (all data)

2021 (all data)

2022 (all data)

2023 (all data)

2024 (all data)

[lbendlin]

Your sample file should come from the source with the most columns.  

It would be better if you would start over and implement the source combine yourself, as you know better than Power Query which columns are required downstream and which can be omitted/ignored.