Power Query update won't finish. How I revised a report that took 1.5 hours to run, down to 5 minutes

I waited for an hour and a half, then pressed Esc.In my day job, I use a summary workbook to count Excel files for contract ...