Skip to content

Troubleshoot issues

Having issues with your data connection on Tableau?

Amazon offers a couple of ways to connect to their internal resources:

  • IAM username and password
  • Token-based authentication i.e. an Access Key

The first and most important point about integrating to PowerBI is that unlike Tableau and other BI tools - we’ve found that it’s a lot easier to use token-based authentication for this purpose. If you try connecting with the IAM method to Amazon Athena from Power BI via ODBC - you get an error like this quite often:

The security token included in the request is invalid

Tallyfy will create and provision the token-based credentials you need as part of the provisioning process for Tallyfy Analytics.

Token-based connection to AWS Athena

You will be given the following from Tallyfy as a substitute for your IAM username and password:

  • Access key
  • Secret access key

In general - regular IAM user credentials (username + password) should be used only to access resources via AWS console - https://aws.amazon.com/ ↗

For all other integrations (just like this ODBC driver) the external service access keys (Access Key and Secret Access Key) should be used.

If you’re experiencing data connection issues in Tallyfy, follow these steps:

  1. Open your Tableau Workbook with the data and graphs.
Tableau Workbook with data and graphs
  1. Change the data connection to blank files. This step may not be necessary unless you want to hide file names.
Changing data connection to blank files
  1. Save the file and exit Tableau.
Saving the file and exiting Tableau

  1. Move the file to a different directory, simulating the transfer of the file to someone else.

  2. Open the file from the new directory. You may encounter an error message if the attached data sources are not in the new directory or filepath.

Error message when data sources are not found
  1. Select “Show Details” to understand the error.
Error details description
  1. Choose “Yes” to connect to your data.
Connecting to data
  1. Select “Edit Connection” if needed.
Selecting Edit Connection
  1. If “Edit Connection” doesn’t work, you may need to remove the connection and add a new one. Unfortunately, there’s no clear explanation why this occurs.
Removing and adding a new connection
  1. Once the connection is established, you’ll see the same information in the dashboard with the new data.
Dashboard with updated data
  1. Don’t forget to adjust the data type of the fields “due_by” and “completed_on” if necessary.
Adjusting data type

Tableau > Connect Tableau to Tallyfy

A comprehensive guide detailing how to establish a connection between Tableau and Tallyfy Analytics data through Amazon Athena using token-based authentication, JDBC drivers, and proper configuration settings.

Powerbi > Connect PowerBI

Tallyfy Analytics integrates with Power BI through Amazon Athena using token-based authentication, requiring an access key and secret access key for seamless data analysis and visualization.

Tableau > Share a Tableau workbook

A comprehensive walkthrough on sharing Tableau workbooks securely by disconnecting data sources and reconnecting them in new locations while maintaining dashboard functionality and visualization integrity.

Analytics > How Tallyfy Analytics works

Tallyfy Analytics processes data by streaming events in real-time, converting them to Parquet format, storing them in Amazon S3, and enabling access through Amazon Athena for SQL queries and BI tool integration.
Get in touch
About Tallyfy