Forum Discussion
dynamically import files from a folder WITHOUT combining them
Hi caninetiger ,
that' not possible through any clever M-function.
The only mechanism that allows such a thing is the navigation dialogue in the Power Query UI and that is controlled by Microsoft.
Connectors like Excel or SQL allow such a procedure, but for CSV this is not possible.
If your csv-files are have less than 1 Mio rows, you could consider creating an xlsx-files with one sheet for each csv-file. But not sure if that would save you much time at the end.
ImkeF Hey, you make a great point here. There's no reason why one couldn't write a custom folder connector to do this. I just wrote one for The Definitive Guide to Power Query (M) so I wonder if I could write a connector that presented all files as "leaves" and just allowed you to select them all. Thanks for the idea Imke!