Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
agupta2481
Regular Visitor

how to import multiple files from folder and keeping all the files separate after importing.

Hi,

 

i need guidance / help in Power BI for the following scenerio

 

1) There is one excel File with Name "Item List", which is being used as one of the referecne point once or multiple times. 

2) there are other multiple Excel Files with different Name "BOM1", "BOM2" etc.  and each of this file needs to be transformed and thus a series of the ETL actions are performed on each of the file

3) all the "BOM1", "BOM2" excel files shall be combined w.r.t to the "Iem List" file .

 

the Problem is as per following:

1) How can i import all the files from a folder to the Power query maintaining the each file seperately. i do not want to import files individually one by one but rather import from the folder. 

2) If the original file ( any file "Item List", "BOM1", "BOM2" )is replaced with the new one(s), Keeping the file name same and all the columns names are also same ( as it is derived from same system but with updated data), will the resultant file ( which is generated after combining/merging/grouping the all the excel files "Item List", "BOM1", "BOM2")  be acquired after doing "referesh". i mean will all the ETL Steps which were applied to the original file will be automatically applied to the new replaced file. 

 

Please advise for solution to this. 

2 REPLIES 2
Anonymous
Not applicable

Hi @agupta2481 ,

 

1. Please try:

In Power BI, go to the Home tab and click on Get Data. --> Select Folder and click on Connect. --> Browse to the folder containing your files and click OK. -->In the Combine Files window, click on Transform Data.

Each file will be imported as a separate query.

vcgaomsft_0-1689903738382.png

We can uncheck the loading of the original table.

vcgaomsft_4-1689904802377.png

For each table we need, reference the original table and rename it.

vcgaomsft_5-1689904951912.png

Then we can deepen the table by filtering the table name first.

vcgaomsft_6-1689905181398.png

Output. Next we can do some conversions on it. 

vcgaomsft_7-1689905233803.png

 

2. Regarding your second question, if you replace the original files with new ones that have the same file names and column names, the ETL steps applied to the original files should be automatically applied to the new files when you refresh the data in Power BI. Just make sure the new files are in the same folder and have the same structure as the original files.

 

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Dear Mr. Gao, 

 

Thanks for your reply and providing me with the solution.

 

for the 2nd Part: i have understood that the "replace the original files with new ones" will work.

for the 1st Part: i am afraid if i have not understood it properly/thoroughly, may one of the reason that i might have not explained it properly. 

 

for the 1st Part, to re-explain the problem ( as i might not be able to explain properly due to lack of supporting files)  , i have now arranged the refence excel files which can be downloaded from link  https://we.tl/t-Aad0uHhf7C

 

 

the Goal is as per following

  1. To use the "Item List" as a base file and combined with the other files like " Stock_Report_All".
  2. All the "BOM1, BOM2, BOM3" files will be individually performed for ETL operation like grouping and later each of this file is combined with the above file..
  3. the final resultant file needed is " Final Target File ( this is combination of the various Files)"
  4. after this the new updated files shall replace the old ones and "referesh" button shall be used.

i hope with this i will be able to explain the issue and seek for the route/path to how to priceed in acquiring the final file.

 

Thansk for your Patience and Cooperation and look forward to have reply from you. 🙂

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors