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 and Greg_Deckler, right now, I think it makes most sense to write a simple python script that takes all the csv files in a folder and writes them either to multiple sheets on an excel file or to a simple database (like SQLite) and then have Power BI/Power Query point to that. This solves the inefficiency of the, clicking "add new query" option, for all the files and allows easier tracking when new tables are added.
If anyone has a better, Microsoft product related idea, I'd love to hear it.