Combine xlsx files from diferent folders

[matdel]

Hello,

I have diferent xlsx files, with same columns names but in diferent sharepoints. I would like to combine all of them in a power bi.

Is it possible to do it even if their location is not in the same place? I have already done it for files in a same folder but not sure it's possible when the files are in diferent locations.

Thank you!

[amitchandak]

@matdel , I doubt, you have to do a manual/code merge, they will not merge automatically in this case