How to connect Airtable to PowerBI using Sync Inc

Sync Inc allows you to connect all your Airtable data to PowerBI.

Sync Inc replicates your Airtable to a standard Postgres database, allowing you to query all your Airtable data in PowerBI using SQL.

In minutes, you'll be using PowerBI to extract insights from across your Airtable workspace and present these metrics in clean dashboards.

Setup Sync Inc

First, connect your Airtable base to Sync Inc. Follow our Quickstart to connect to walk through the the connection steps and retrieve the credentials for your Sync Inc Postgres database. You'll use these credentials in PowerBI:

Sync Inc Postgres database credentials

Connect Sync Inc to PowerBI

Sync Inc databases are hosted on AWS RDS.

Note: Sync Inc can also sync directly to a Postgres database you manage (which you may have already connected to PowerBI). If you are interested in this option, just send us a note.

To connect to an AWS RDS database from Power BI, you need to tell PowerBI it can trust AWS with a certificate. Here is how:

  1. First, you need an AWS public key in the PKCS#7/P7B format. You can follow the steps in this help doc to download a public key and convert it. Or, if you want to save yourself the time, you can download the key in the proper format here ⏬.
  2. You need to import that certificate as a Trusted Root Certificate. To do that, follow the steps outlined here. Don't let the old UI screenshots fool you, this will work on any PC.
    • In the help doc you will be asked to first add the certificate to “Intermediate Certification Authorities” and then add the certificate to “Trusted Root Certification Authorities” — skip the Intermediate part. Again, you’re just looking to add a certificate for The Trusted Root Certification Authorities
  3. Once that certificate is in place, you should be able to connect to your Sync Inc database. However, PowerBI might not let you use our friendly DNS name presented in the Sync Inc Console. So instead, use this hostname: `ghola-ext-prod-1.cthqctzktvig.us-west-2.rds.amazonaws.com`

For clarity, your connection credentials will be:

FieldValue
Host:`ghola-ext-prod-1.cthqctzktvig.us-west-2.rds.amazonaws.com`
Port:`5432`
Username:`username` from Sync Inc Console
Database:`database` from Sync Inc Console
Password:`password` from Sync Inc Console

Connecting more than one Airtable base to PowerBI

If you would like to connect more than one Airtable base to PowerBI, then you'll need to configure Sync Inc to sync each Airtable base to a unique schema within the same RDS database. This is a setting we will be bringing to the Sync Inc console soon - but for now, please just send us a note and we'll get this set up for you.

Retool

Was this helpful?