Reducing the Size of a Salesforce Extract

Published: 27 Jan 2015
Last Modified Date: 19 Dec 2019


How to reduce the amount of rows retrieved from Salesforce database.


  • Tableau Desktop
  • Salesforce


A possible workaround to reduce the size of the data set is to remove any unused fields: 
  1. After establishing a connection to Salesforce, drag the relevant tables into the Data window. 
  2. Within the metadata, right-click on the field titles that to be excluded from the extract and select Hide
When a field is hidden and an extract is created the data associated with that field is not included in the extract, reducing the amount of data imported. 

Additional Information

The ability to limit the number of rows in a Salesforce extract is functionality not currently available in Tableau Desktop. 

To voice your support for the inclusion of this enhancement in a future product release, add your vote to the following Community Idea: Filter Data for Sales force Extract.

Discuss this article... Feedback Forum
Did this article resolve the issue?