Forum Discussion

cdok1091's avatar
cdok1091
Advocate II
9 years ago

dynamically import files from a folder WITHOUT combining them

Hi all, I'm looking to upload multiple files of the same type from a single folder into Power BI Desktop.  However, in this case, I don't want to combine them into a single query.  How can I dynamic...
Need Help
caninetiger's avatar
caninetiger
Frequent Visitor
2 years ago

Has anyone found a solution to this problem? ImkeF is there any way to build a custom function in M that takes a list (or column) of tables and "adds new query" for each of them? I have 300+ csv files in a downloaded folder I need to import into Power BI on a regular basis. It would be a nightmare to have to click "add new query" for every one of them and then, worse, track if any additional csv files are added to the folder over time.

 

Using the folder import option from "get data" I get far enough that I have a list of tables (see pic below) with each table representing one of the csv files in the folder. But I don't know of a method that can split that single query into multiple queries without manually clicking the "add new query" button.

 

Is this possible? Any help would be appreciated.

 

Best,

Yisroel