title: How to add parameters to an external data query in Excel which can't be displayed graphically?
body: <p>I often use MS Excel's <code>Get External Data</code> to create simple reports - running queries against databases and displaying nicely in Excel. Excel's great features like filtering and pivot tables and familiar interface for users make it quite good for this. However, one limitation with Microsoft Query is you can't add parameters to queries that can't be displayed graphically, which considerably limits the SQL you can write. </p>
  
  <p>Is there any solution to the error "parameters are not allowed in queries that can't be displayed graphically"?</p>