After working with all sorts of Airtable users to get their bases connected to PowerBI, I wanted to provide a quick tutorial to the community in case you might be looking to connect Airtable to PowerBI as well.
Generate the API request to pull the data from your desired Airtable base and a specific table. Here is the basic format: https://api.airtable.com/v0/[BaseID]/[NAME_OF_THE_TABLE]?Api_key=[API_KEY]
In Power BI, select Get Data and enter the properly formatted URL you just created
Now, set up pagination so you can pull in more than 100 records. Do so by clicking the “Advanced editor” button and enter the pagination function here.
Rinse and repeat with each of the tables you want to bring into Airtable.
Create a Sync Inc account and connect to your base.
In PowerBI, add a trusted certificate for your Sync Inc database which you can get from the Sync Inc docs.
Connect to your Sync Inc Postgres database in PowerBI using the standard Postgres connector.
Once your Airtable data is in PowerBI, you can create metrics and dashboards with just a couple clicks. It’s a great service for pulling insights out of your Airtable base, combining them with other data sources, and sharing the data with your team.
The key step is to add a root certificate to your computer so you can properly connect to your Sync Inc database. It is as easy as clicking and uploading a file. And this video shows you exactly where to click :computer_mouse: