title: How can I query a Salesforce object to return only specific fields (columns)?
body: <p>I created a connection with Salesforce. Selected the Account object which has 100s of fields (we've maxed out the allowed number of fields). This errors out with the error below (Requested URI Too Long).</p>
  
  <p>This works fine on smaller tables.</p>
  
  <p>Is there a way to create a custom query that selects only the fields (columns) I want? Either by modifying the automatically-generated query:</p>
  
  <pre><code>let
      Source = Salesforce.Data("[salesforce URL]", [CreateNavigationProperties = true]),
      Account1 = Source{[Name="Account"]}[Data]
  in
      Account1
  </code></pre>
  
  <p>OR by modifying the actual SOQL request that is sent to Salesforce?</p>
  
  <p>Here's the error</p>
  
  <pre><code>DataSource.Error: Web.Contents failed to get contents from '[salesforce URL]/services/data/v29.0/query?q=SELECT%20Id%2CIsDeleted%2C&lt;MANY ADDITIONAL FIELDS DELETED&gt;(414): Request-URI Too Long
  Details:
      DataSourceKind=Salesforce
      DataSourcePath=[Salesforce URL]
      Url=[Salesforce URL]/services/data/v29.0/query?q=SELECT%20Id%2CIsDeleted%2C&lt;MANY ADDITIONAL FIELDS DELETED&gt;Product_Interest__c%2CFea...
  </code></pre>