Forum Discussion
NickzNickz
3 years agoHelper IV
Combine and append data from multiple excel files
Hi.. I have multiple excel files and data table in excel file as below. The file name is different each month and years. How can I combine and append the data in Power BI. I try to avoi...
- 3 years ago
Hi NickzNickz
Please check this, there's too much to rewrite it all here
Import Multiple Files Containing Multiple Sheets with Power Query • My Online Training Hub
regards
Phil
PhilipTreacy
3 years agoSuper User
Hi NickzNickz
Please check this, there's too much to rewrite it all here
Import Multiple Files Containing Multiple Sheets with Power Query • My Online Training Hub
regards
Phil
- NickzNickz3 years agoHelper IV
Hi PhilipTreacy ,
Thank you for the link .... I also found another video https://www.youtube.com/watch?v=OKoWEhb8Yek ... This one is for multiple tables ... Similar process/steps ....
Regards,
NickzNickz