Salesforce Dates Converting to UTC in Tableau Desktop

Issue

When using a data source with data stored in a particular time zone and then connecting to Tableau Desktop, the date data may not be accurate according to the originally intended time zone.

For example: if Salesforce data is stored with Mountain Time and the Tableau Desktop workbook is configured with the Automatic Locale setting, then the timestamp values appear in UTC in Tableau Desktop and each are off by six hours.

Environment

Tableau Desktop
Salesforce.com

Resolution

Use calculated fields to adjust the time field values in Tableau Desktop. To view example, see the following articles in the Tableau Knowledge Base:

Cause

The Salesforce API that Tableau Desktop uses to connect to Salesforce data converts date and datetime fields into Coordinated Universal Time (UTC).

Additional Information

To voice your support for the inclusion of this feature in a future version of Tableau Desktop, please vote up the following Idea in our Community: Timezone conversion support.

For additional information about Primitive Data Types, see the SOAP API Developer Guide.