Incremental Import for Power Query
I've encountered this a few times with people who have lots of data that needs to be imported, but not all of the data needs to be imported every time.
In one case, a client imports weekly data and ideally, they'd like to keep years of data in one place. The problem is they only need the last week's data imported, not all of the previous data re-imported.
The problem is when there's so much unnecessary data being re-imported that the queries take more than 1 hour and sometimes crash.