Help needed to connect Airtable to Power BI / Excel

[Hugo_Le_Morvan]

Hi Everyone,

I am using Airtable as my CRM. I love it. However, the data vizualisation blocks are not enough and I would like to create comprehensive dashboards in Excel or Power BI.
I am not a technical guy but I managed to connect the API for small tables.
However, my 2 main tables have 25k and 8k rows… I do not know how to do it for these ones.

I would like to have my data updated daily so I can share it with partaners.

Is the API allow this task ? Anyone can help ?

Thanks a lot,

Hugo Le Morvan

[Tuur]

Hi Hugo,

What are the issues you are running into?

FYI: My clients are using a custom made web service connecting up to 100 separate Airtable bases (all synchronized fast and perfectly). The amount of data should not be a problem. :slightly_smiling_face:

Feel free to contact me with a private message!

Best,

Arthur.

[openside]

Hey Hugo, we too can help here. Very familiar with the API as well as working with PowerBI.

Ping me at dan@openside.com

[Matthew_Billio1]

A bit late possibly? But here is how you can have it automatically imported into excel:

Airtable link to Excel via Power Query Show and tell

Here is a way to automatically pull information from airtable into Excel via power-Query using a bit of coding. If you are looking to just copy and paste the code you need without much explanation, ignore the details :slight_smile:

Details

SECTION 1- CONNECTING EXCEL TO POWERQUERY- The first issue a user may run into while trying to get data to automatically feed into Excel is creating an authenticated connection to Airtable from Excel’s powerQuery. The following code will be used in a later …

[Inna_Shevchenko]

Hello @Hugo_Le_Morvan !

I recommend checking data integration tools that can help you move data from Airtable to Excel or Google Sheets. There are a bunch of data integration tools or ETL tools that can help, such as Coupler.io.