Forum Discussion
Help please, Filtered File Folder import still evaluates contents of files filtered out
I have a folder that contains monthly files that go back years. For my purposes I only require the last 12 months. I filter the created date. This works fine, and the resultant import is limited to ...
Hi I_Like_Pi
Use Transform File sample query
Import all files once with Combine & Transform.
In the generated query list, apply your date filter in the “Transform Sample File” step, not the main folder query.
This way, Power Query filters early, before full load.
Thanks✨🌹
buttom kudo