Tableau > Connect Tableau to Tallyfy
Troubleshoot issues
Nothing’s more frustrating than a broken data connection right when you need your dashboard. Here’s how to fix common Tableau connection problems with Tallyfy Analytics - and prevent them from happening again.
Amazon Athena (which hosts Tallyfy Analytics data) gives you two ways to authenticate:
Authentication Method | Recommended For | Common Issues |
---|---|---|
IAM Username/Password | AWS Console access only | Frequent “security token invalid” errors with BI tools |
Access Key/Secret Key | All BI tool connections | More reliable, fewer token expiration issues |
You’ll get two credential sets from Tallyfy when they set up your Analytics account:
- AWS IAM Login - Use only for AWS console access at https://aws.amazon.com/ ↗
- Access Key and Secret Access Key - Use for connecting Tableau to Athena
That dreaded “The security token included in the request is invalid” error? Here’s what to check:
- Verify you’re using the Access Key/Secret Key (not IAM credentials)
- Check that your credentials haven’t expired
- Ensure you’re using the correct region setting
Your workbook’s data connection went missing? Don’t panic. Follow these steps:
-
Open your Tableau workbook with the disconnected data source
-
When prompted about the missing data source, select Show Details to view the specific error
-
Click Yes when asked if you want to connect to your data
-
Select Edit Connection to update your connection settings
-
Enter your Access Key, Secret Access Key, and other connection details
-
If the connection is successful, your dashboard will refresh with the current data
Sometimes the Edit Connection option just won’t work. When that happens:
- Remove the existing connection completely
- Create a new connection to Amazon Athena
- Re-enter all connection parameters using your Access Key and Secret Access Key
- Reconnect to your data tables
After reconnecting, your date fields might look weird. Fix them like this:
- In the Data Source tab, locate fields like “due_by” and “completed_on”
- Right-click each field and select Change Data Type > Date & Time
- Verify that date comparisons and calculations now work correctly
Need to share your masterpiece with colleagues? Keep these security tips in mind:
- Use Tableau’s Extract feature to create a local copy of the data
- Alternatively, use Published Data Sources in Tableau Server/Online
- For direct connections, ensure recipients have their own Tallyfy Analytics credentials
- Never embed your credentials in shared workbooks
Want to avoid these headaches in the future? Here’s what works:
- Keep Tableau Desktop and drivers up to date
- Use Tableau’s Test Connection feature regularly
- Document your connection settings in a secure location
- Create data extracts as backups for critical dashboards
- Schedule regular extract refreshes if using Tableau Server/Online
Still stuck after trying everything? Contact Tallyfy Support with specific error messages and screenshots - they’ll sort you out.
Tableau > Share a Tableau workbook
- 2025 Tallyfy, Inc.
- Privacy Policy
- Terms of Use
- Report Issue
- Trademarks