Forum Discussion

agupta2481's avatar
agupta2481
Regular Visitor
3 years ago

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.  ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.

We can uncheck the loading of the original table.

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

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

Output. Next we can do some conversions on it. 

 

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

agupta2481's avatar
agupta2481
Regular Visitor
3 years ago

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. ðŸ™‚