Single Power Query for Multiple Files with minor change

Hi SSG0401 

The connector is there, you just need to serach 

Without knowing the setup at your company and if it's possible, the Sharepoint folder can be the new source for all files and the Excels are shared individually with each Excel Owner. 

The folder will be the new source. When you load in the first Excel and implement the Power Query Code minus the old source information, as this will be created new when importing into Power BI. The added folders later will be automatically changed to the transformations of the first file added. 

Do some testing, make a copy of 3 of the files and try it out.

Depending on the complexity of the Excels and the licence situation in your company, the best solution here would be a Power App that writes the data to one source, the source could be as simple as a CSV or one Excel or even a SharePoint list.

Thanks

Joe