Creating a merged table

[excelos]

Hello

I have the following sources:
1) xls file with a table in it, saved in Sharepoint
2) filename of the xls file

I want to create a merged table where the table from the xls is copied and another column is added where the fields are populated with the filename of the xls file.

I can do that with any of these tools or a combination:
1) Sharepoint lists or other Sharepoint functionality
2) Salesforce
3) PowerBI

Can you tell me please what is the easiest way to do it?

Thanks!