Very slow Power Query refresh

Hey everyone, first-time poster here! I am having some issues with a Query refresh that we have to do on a weekly basis. It basically goes into a Sharepoint folder, opens and merges all of the files...