Forum Discussion
Import multiple csv files from a folder
Hi i am trying to import multiple csv files from a folder, but it is combining all files to create a single table,but i don't want to combine the files,i want tables separately to be loaded in data m...
In Power Query, one table one file principle is followed. When you select a folder, the end result will still be one table only (in general people choose to combine to produce that one table).
For your case, if there are 10 files, you will need to load all 10 files individually.
This is still a long pending demand from PQ community that we should get flexibility to load files in one go if we need more than one table.