Dec 05, 2018 12:20 AM
I do not seem to find this anywhere on the community, so thought of sharing it.
With the use of API key, we can easily integrate Airtable bases into power bi and design dashboards.
In the PBI desktop got --> Get Data --> Web --> Advanced
Click OK and your table will reflect here.
This process has to be repeated for each table in the Base.
Also, if a field is linked record type, this shows as a bunch of alphanumeric in the PBI. To avoid this, in the table create a new column next to linked record field and use ARRAYFLATTEN formula to overcome this alphanumeric and effectively present data in PBI.
One thing I still did not figure out is how to set auto-refresh in PBI online as it shows to edit credentials to enable auto-refresh and I am not sure in what way/format I should enter them. If anyone has an idea please tip me.
Dec 11, 2018 04:44 PM
Hey there!
I used this process but for some reason when pulling the columns, it’s only bringing 23 instead of the total amount, do you know how to pull all columns?
Apr 15, 2019 10:14 AM
Hi I have tried this but it’s not pulling up my records from Airtable. They show up in the web view but when I load it into PowerBi, it’s not showing any data to import.
Any help on why this might be?
Thanks.
May 13, 2019 11:23 AM
Can anyone elaborate on the OP’s advice to use arrayflatten to convert the alphanumeric codes to the actual values from linked records? I have been searching all over and cannot find a solution to this.
Thank you
Oct 14, 2019 02:32 PM
It’s funny how so many threads about connecting Airtable and Power BI just go dead and unresolved. Did anyone in this thread find a solutiuon for this?
Oct 15, 2019 11:52 PM
@Plinio_Averbach
If you go to the bottom of this post, we’re almost there:
Jun 11, 2020 04:53 PM
Hello! I is dead, Airtable asks for newer browser.