I am getting the following error message when trying to refresh my data in Tableau from Salesforce - Unable to complete action Not all extracts were refreshed An error occurred while refreshing Contacts and Activities An unknown error related to remote content was detected (500) INVALID_SESSION_ID: Invalid Session ID found in SessionHeader: Illegal Session Unable to create extract An error occurred while refreshing belongto.my.salesforce.com An unknown error related to remote content was detected (500) INVALID_SESSION_ID: Invalid Session ID found in SessionHeader: Illegal Session An error occurred while refreshing Lead+ (belongto.my.salesforce.com) An unknown error related to remote content was detected (500) INVALID_SESSION_ID: Invalid Session ID found in SessionHeader: Illegal Session An error occurred while refreshing B2 Group Attendance (belongto.my.salesforce.com) An unknown error related to remote content was detected (500) INVALID_SESSION_ID: Invalid Session ID found in SessionHeader: Illegal Session An error occurred while refreshing B2 Group Attendance (belongto.my.salesforce.com) (2) An unknown error related to remote content was detected (500) INVALID_SESSION_ID: Invalid Session ID found in SessionHeader: Illegal Session An error occurred while refreshing Contact+ (belongto.my.salesforce.com) An unknown error related to remote content was detected (500) INVALID_SESSION_ID: Invalid Session ID found in SessionHeader: Illegal Session An error occurred while refreshing Referrals and Signposting (belongto.my.salesforce.com) An unknown error related to remote content was detected (500) INVALID_SESSION_ID: Invalid Session ID found in SessionHeader: Illegal Session Also I have to sign in about 8 times to get the refresh to even start.
"This is a common issue with the Tableau-Salesforce connector, often related to API limits, OAuth token expiration, or object schema changes.
1- Try the following steps to fix it:
Re-authenticate OAuth: Go to Tableau, edit your Salesforce connection, and sign in again to refresh the OAuth token.
2- Check API Permissions:
Ensure the Salesforce user profile used for the connection has the "API Enabled" permission checked.
3- Schema Changes:
If any custom fields were recently deleted or modified in Salesforce, it will break the extract. Refresh your data source schema in Tableau.
4- Apply Filters:
If the extract size is massive, Salesforce might enforce a query timeout. Try filtering the extract to fetch a smaller date range or subset of data."
