Airtable provides a developer platform which allows you to create, read, update and delete records in a given base. Using the Airtable REST API, we’ve seen organizations create sophisticated data pipelines between Airtable and other services, such as Microsoft Power BI.
This support article outlines a solution for Power Query / Power BI that allows you to pull in records from an Airtable table. The script referenced in the document is available in this Github repository.
The software made available from this repository is not supported by Formagrid Inc (Airtable) or part of the Airtable Service. It is made available on an "as is" basis and provided without express or implied warranties of any kind.