title: Power Query 'an evaluation is in progress' when merging
body: <p>When merging two tables in PowerQuery an evaulation is run to determine the possible number of matches. I run pretty large tables (merge a 10K record table with a 500K record table) so this can take a long time.</p>
  
  <p>I know there will be matches because I have done this before and I am not a beginner. Yet PowerQuery insists on running this behaviour.</p>
  
  <p>Is there anyway to baypass this step? It almost feels like when you just need to turn automatic calculation off in Excel so that you can get on with actually doing something.</p>
  
  <p>Any ideas?</p>