Right approach in Folder load on folder design ?

[Paulyeo11]

Hi All

I am still not sure for the right approach on to put all the raw data file in one folder or to save them in individual folder ? Hope some one can share with me.

[negi007 · Accepted solution]

@Paulyeo11 When you are importing files from your folder, instead of selecting combine and transform data, select transform data.

on your powequery you will get the list of all the files, right click on the binary option and select add as a new query to select individual files. 

Once you have all your files in powerquery window, then you can select and merge them into one

[Paulyeo11]

Hi Negi

Let said i put all the file in one folder , and for the start i select one file to PBI , and when it work fine , Can i still add more similar data structure file to PBI ? or i need to select all the file and combine them ?

Paul

[Paulyeo11]

Hi negi 

I have found the solution now. thank you.

[Anonymous]

@Paulyeo11 - save all the files in one folder, and when the files are loaded in Power BI, they will get loaded with the respective file names.

[Paulyeo11]

Hi Sir

it there a way i can select to load only file name with AP_XX.SCV ? So that i can group these file as Account Payable. and AR_XX.CSV for Account Receivable. 

Can