title: Dynamic Parameter in Power Pivot Query
body: <p>We are using Excel 2013 and Power Pivot to build modules that consist of several Pivot tables that are all pulling data from the same Power Pivot table, which queries our T-SQL data warehouse. </p>
  
  <p>In an effort to simplify and fully automate this module, we wanted to create a text field that would allow a user to enter a value (a client ID# for example), and then have that value be used as a parameter in the Power Pivot query. </p>
  
  <p>Is it possible to pass a Parameter in the Power Pivot query, which is housed in a text field outside of the query? </p>