Forum Discussion
Power Query not behaving as expected.
I use a Power Query that pulls data from files in a folder, the data is a daily report of product that has been transferred from one warehouse to another. Typically, the cartons of product are scanne...
It looks like the file with the empty Column 8 is taken as the sample file and that column is ignored for all other files.
You need to check query Transform Sample File in Transform File from SomeName group and edit it manually if necessary. Pay attention to parameters for the source file loading. And be careful with changing of that query, better to play on copy of you main file first.