combining multiple file

Hi folks , Thanks for the help in the past .

I needed an help .Hope i will get the knowledge for it .

I have to connect a teams channel in power bi .

The channel have a folder , contains csv file report which is sheduled from an other tool.

so every day , 1 csv file is coming in the folder .

I need to append this files  means , if first file have 10 rows and seconf file have 8 rows 

so result have 11th row =1st row of second file , and so on .

Apending process should be dynamic .

Please help me to make this happen