Power query for a large dataset

My company uses a horrible format for its daily production sheets, but the data can be pulled through power query.

I want to build a reporting tool for looking at any major trends that are currently missed. Ideally looking at part efficiency by machine type and some other descriptive data too like efficiency by shift manger etc.

My problem is that even after cutting unnecessary columns and filtering unnecessary rows, it takes forever to load anything. ChatGPT isn’t all that helpful, I’d like some expert advice please!

For info, rough number of rows of data is about 50,000 per year. I want to cover at least the last three years.

Sheets are all saved into a folder by month, within a folder by year.