Excel Power Query on SharePoint Online - update not working

Excel Power queries have been created to collect and merge customer data. Due to size issues, the data is consolidated in two different files (one for 2020 and another for 2021). A summary report com...