Load multi folder by M Code ?

[Paulyeo11]

Hi All

I have sales order table in CSV file for 10 company . All load by folder.

I also have GL table in CSV file for same 10 company Can I create a PBI file = sales order by load all table using folder.

And I also create a PBI file = GL by load all table using folder.

Once above 2 step successful then I combine the above 2 PBI file M code , so now my sales order and GL both table combine in one PBI file. It above approach have any issue in future ?

Paul

[v-yingjl · Accepted solution]

Hi @Paulyeo11 ,

If the files under the folder have the same file type like .csv etc. , you can combine them when connecting to the folder in power query.

Refer:

1. Load but not combine multiple files from a folder 
2. Combine files in a folder with Combine Binaries (Power Query) 
3. Import Multiple Files from a Folder with Power Query 

If the folders have some 'relationships' like parent-child etc. ,you can follow these steps to combine:

      1. Get data from the parent folder.

      2. Add filter to find out ther related folder.

let
    Source = Folder.Files("C:\Users\xxxxxx\Desktop"),
    FolderFilter= Table.SelectRows(Source, each [Folder Path] = "C:\Users\xxxxxx\Desktop\file\" or [Folder Path] = "C:\Users\xxxxxx\Desktop\Read\"),
    NameFilter = Table.SelectRows(FolderFilter, each [Name] ="abc.xlsx" or [Name] ="cde.xlsx" )
in
    NameFilter

Refer:  Combine multiple "FOLDERS" (not files) 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Paulyeo11]

Hi Ying

Thank you for sharing.

Paul

[Fowmy]

@Paulyeo11 

Once you bring all the queries under one table as you have followed, there will not be an issue. 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn