title: Powerquery - reference Excel cell value within SQL query?
body: <p>I am trying to modify an excel worksheet that was given to me, with a connection to a SQL database that looks as follows:</p>
  
  <pre><code>select * from DB.AccountAssignments where Company_Code = '102'
  
  </code></pre>
  
  <p>How can I replace the static 102 value to reference a specific cell in Excel? For example, cell A1? The objective of course, being that when I change the 102 for a different value, the query will re-run without having to enter PowerQuery to edit the query it self each time.</p>
  
  <p>NOTE: I found examples that involve filtering AFTER the query runs and pulls the data. However, the data source is HUGE so I need the Company Code parameter to be embedded within the query, so that the data brought into Powerquery is already filtered. That makes the difference between the query taking 5 seconds to run to 5 minutes to run.</p>
  
  <p>I spent a couple hours attempting instructions on older posts, but have not been successful so far.</p>