Forum Discussion
Question regarding Data Transformation Not Recognizing ALL Data
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...
lbendlin
Super User
Super UserYour 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.