Last Modified Date: 14 Nov 2017
- Tableau Desktop
ResolutionDepending on the specific field and object, the issue may be resolved in one or all of the following ways:
Option 1Create a connection to the correct table, where the desired fields are located. This might require using a join or creating a custom connection. For more information, see Connecting to Salesforce Data Source.
Option 2If the field type is defined as a formula in Salesforce.com, it will not import due to limitations with the Salesforce API. You must connect to all of the tables that contain the fields in the formula and use that data to create a calculated field.
Option 3If the field is defined as a Long Text Area, you will need to change it to a text field.
Note: "Long Text Area" field types are not automatically excluded based on field type alone. "Long Text Area" fields are only excluded if they exceed the 4096 character limit. For more information, see Errors during extract.
CauseThe issue can be caused by one of the following:
- The field exists in a different table than originally thought. Fields in Salesforce.com can be referenced across several tables.
- The field is defined as a formula in Salesforce.com
- The field is defined as Long Text Area in Salesforce.com
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials