title: Selecting a schema to connect to when connecting over an ODBC connection in Excel's Power Query
body: <p>So I have a fairly simple query (proof of concept) where I'm able to dynamically pull in data from a database depending on my Excel sheet inputs. For example:</p>
  
  <pre><code>let
      Source = Odbc.Query("dsn=Dev 2", "select * #(lf)from job_id JI#(lf)where JI.job_ID  = " &amp; Text.From(GetNamedRange("SQLJobInstanceID")) &amp; "#(lf)")
  in
      Source
  </code></pre>
  
  <p>Hurray, it works! However, when I was setting up the connection, I needed to log in. Part of the login includes the schema that I wanted to connect to. <code>Username[Schema]</code> is how it's done. Now that I've connected, I'd like to select a different schema to connect to - but I'm not sure how I can either modify the schema, or log out and log back in. </p>
  
  <p>(Also curious if the connection is storing my credentials, which would be problematic, or if other people would need to log in with their credentials)</p>
  
  <p>I believe I can also edit which ODBC connection I'm using by editing the <code>"dsn=Dev 2"</code> portion of the code (Again, will probably turn it into a named range drop down menu.... the challenge becomes dynamically figuring out what ODBC options each user has and pulling those through...)</p>
  
  <p>Thank you</p>