I have a power query in sharepoint that consolidates all a folder with many other excel files. How do i make it such that it refreshes automatically without opening it?

hi all, as my title states. the total rows adds up to around 100k , up to 500k by the end of the year. it takea me roughly 5 to 10 mins for the power query to fresh the entire dataset manually each time.

This consolidated file is also used my many others.

Hence i was wondering if i can have it auto refreshed lets say first thing in the morning.