Connecting Power BI to Amazon Athena to get Tallyfy Analytics
Tallyfy offers analytics over your workflows to a range of BI and analytics tool - making it a great fit for people who are familiar with Power BI. We're one of the only workflow platforms that set your data free so that you can slice, dice and report on it in any way you see fit. Next time you are thinking of deploying a self-service workflow and approval management solution (designed for business users) via IT/across the company - think about Tallyfy.
Tallyfy stores your data as parquet files in Amazon S3 and automatically updates them whenever a change is made. We use Amazon Athena to give you access to these files - a scalable, serverless way of running queries across large datasets.
This article will explain how to connect Power BI to the data in Amazon Athena, using the ODBC connector. All this assumes you have a Tallyfy account with analytics enabled, of course!
Install and configure the Amazon Athena ODBC Driver for usage on Power BI
First, you will need to install the Amazon Athena ODBC Driver. You can download the appropriate version for your operating system from this page.
Next you will need to configure the driver. How to do this depends on your operating system. Step by step instructions are available in the documentation, which can be downloaded from the same page.
On Windows, you can include the authentication credentials in the configuration process. The credentials will be provided to you by Tallyfy.
Using the connector in Power BI
This video walks through how to connect to Amazon Athena using the ODBC connector.
After opening Power BI Desktop, click Get Data, and select the category Other, and choose ODBC, and click Connect.
The connector will ask you to pick a Data Source Name. Chose the Data Source name you set up in the configuration process, and Click OK. Then on the left panel, open the catalog and database, and then select your table. A preview of the data should appear.
Click Load at the bottom to load the Tallyfy data into Microsoft Power BI.