Combine and append data from multiple excel files

[NickzNickz]

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 avoid having the data staging files in excel format.

From excel perspective yes I manage to do it. However, there is a requirement to do it in Power BI ....

Anyone can help me on this ...

Regards,

NickzNickz

[PhilipTreacy · Accepted solution]

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

[NickzNickz]

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