{"id":12336,"date":"2026-07-09T16:23:00","date_gmt":"2026-07-09T16:23:00","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=12336"},"modified":"2026-07-22T14:10:08","modified_gmt":"2026-07-22T14:10:08","slug":"how-to-get-data-from-airtable-into-power-bi","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/","title":{"rendered":"How to get data from Airtable into Power BI"},"content":{"rendered":"

Introduction<\/h2>\n

\"Airtable\"<\/a>Airtable is a cloud-based platform that combines spreadsheet-style usability with relational data capabilities. Many teams use Airtable to manage projects, CRM pipelines, operations, and content workflows. To analyze this data at scale, you can connect Airtable to Power BI and build interactive reports.<\/p>\n

Using the ZappySys ODBC Driver for REST APIs, you can query Airtable API data with SQL and load it into Power BI without writing custom integration code.<\/p>\n

This tutorial shows how to create an Airtable ODBC DSN, configure API authentication, preview table data, connect Power BI, and run practical SQL queries.<\/p>\n

Prerequisites<\/h2>\r\nTo access your data in your app using the ODBC Driver, ensure the following requirements are met.\r\n\r\nDownload and install ZappySys ODBC PowerPack<\/a><\/div>\n

Steps<\/h2>\n

Create an Airtable Personal Access Token<\/h3>\n
    \n
  1. Sign in to your Airtable account<\/a>.<\/li>\n
  2. Go to the Airtable token page<\/a> and click to create a new token.<\/li>\n
  3. Grant the minimum required scopes for your scenario, such as data.records:read<\/span> and schema.bases:read<\/span>.<\/li>\n
  4. Allow access to the specific base(s) and copy the token to a secure location.\n
    \"\"<\/a>

    Airtable – Create a token<\/p><\/div><\/li>\n<\/ol>\n

    Get Airtable Base ID and Table ID<\/h3>\n
      \n
    1. Open the target table in Airtable.<\/li>\n
    2. Copy the Base ID and Table ID from the URL or API documentation page<\/a>.<\/li>\n
    3. Keep these IDs handy because you will use them in the API URL, for example:
      \nhttps:\/\/api.airtable.com\/v0\/{BASE_ID}\/{TABLE_ID}<\/code><\/li>\n<\/ol>\n

      Create a New ODBC DSN Using ZappySys JSON Driver<\/h3>\n
        \n
      1. Search for ODBC<\/strong> in the Windows Start menu and open ODBC Data Source Administrator<\/strong>.
        \n        \"\"<\/a><\/li>\n
      2. In User DSN<\/strong> or System DSN<\/strong>, click Add<\/strong>.<\/li>\n
      3. Select ZappySys JSON Driver<\/strong>, then click Continue<\/strong>.
        \n        \"\"<\/a><\/li>\n<\/ol>\n

        Configure Airtable API Connection<\/h3>\n
          \n
        1. Enter the Airtable API URL in this format:
          \nhttps:\/\/api.airtable.com\/v0\/{BASE_ID}\/{TABLE_ID}<\/span><\/span><\/li>\n
        2. In Connection Type<\/strong>, select HTTP<\/strong> and click Configure<\/strong>.<\/li>\n
        3. Set Credential Type<\/strong> to Static Token \/ API Key<\/strong>.<\/li>\n
        4. Paste your Airtable Personal Access Token in the token field.<\/li>\n
        5. Click OK<\/strong> to save HTTP authentication settings.\n
        6. Set HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
        7. Set JSON Path Filter<\/strong> to:
          \n$.records[*]<\/code><\/li>\n
        8. Click Test Connection<\/strong>, then click OK<\/strong> to save the DSN.\n
          \"\"<\/a>

          Airtable – JSON Driver configuration<\/p><\/div>\n

          <\/div>\n<\/li>\n<\/ol>\n

          Preview Airtable Data in ODBC Driver<\/h3>\n
            \n
          1. Open the Preview<\/strong> tab in the DSN configuration window.<\/li>\n
          2. Generate a query and click Preview Data<\/strong>.<\/li>\n
          3. Confirm rows are returned. If not, recheck token permissions, Base ID, Table ID, and JSON Path Filter.\n
            \"\"<\/a>

            Airtable – JSON Driver result<\/p><\/div><\/li>\n<\/ol>\n

            Connect Power BI to Airtable via ODBC<\/h3>\n
              \n
            1. Open Power BI Desktop<\/strong>.<\/li>\n
            2. Go to Home<\/strong> > Get Data<\/strong> > More…<\/strong>.<\/li>\n
            3. Search for ODBC<\/strong> and click Connect<\/strong>.\n
            4. Select your Airtable DSN from the data source list.<\/li>\n
            5. Optionally enter a custom SQL query in Advanced options<\/strong>.\n
            6. Click OK<\/strong>, review the preview, and click Load<\/strong>.\n
            7. In the Navigator, select fields or tables you want to import into your model.<\/li>\n<\/ol>\n

              Query Airtable Data with SQL<\/h3>\n

              Use custom SQL queries in the ODBC driver or Power BI to shape data before loading, depending on your database; here are some examples for our table.<\/p>\n

              Example 1: Select Common Airtable Fields<\/strong><\/p>\n

              SELECT\r\n    id,\r\n    createdTime,\r\n    fields_Name AS Name,\r\n    fields_Status AS Status,\r\n    fields_Owner AS Owner,\r\n    fields_Amount AS Amount\r\nFROM records<\/pre>\n
              Example 2: Filter Active Records<\/strong><\/p>\n
              SELECT\r\n    id,\r\n    fields_Name,\r\n    fields_Status,\r\n    fields_Priority\r\nFROM records\r\nWHERE fields_Status = 'Done'<\/pre>\n
              Example 3: Recent Records (Last 7 Days)<\/strong><\/p>\n
              SELECT\r\n    id,\r\n    fields_Name,\r\n    createdTime\r\nFROM records\r\nWHERE createdTime >= <<today-7d,FUN_TO_DATE>><\/span><\/pre>\n
              Example 4: Group by Status<\/strong><\/p>\n
              SELECT\r\n    fields_Status AS Status,\r\n    COUNT(*) AS RecordCount\r\nFROM records\r\nGROUP BY fields_Status\r\nORDER BY RecordCount DESC<\/pre>\n
              Conclusion<\/h2>\n
              Connecting Airtable to Power BI using the ZappySys ODBC Driver gives you a fast, SQL-friendly way to build analytics on top of Airtable API data. You can centralise operational data, model it in Power BI, and publish dashboards for your team without building custom connectors.<\/p>\n
              Explore the full capabilities of the ZappySys ODBC Drivers<\/a> to integrate Airtable and other APIs into your reporting workflow.<\/p>\n
              Need Help?<\/h3>
              If you encounter any issues, our support team is here to help:<\/p>\r\n\r\n
                \r\n \t
              1. Live Chat:<\/strong>\u00a0Open the chat widget\u00a0(bottom right of this page)<\/em><\/li>\r\n \t
              2. Email:<\/strong>\u00a0support@zappysys.com<\/a><\/li>\r\n \t
              3. Support Center:<\/strong>\u00a0Support | ZappySys<\/a><\/li>\r\n<\/ol><\/div>\n","protected":false},"excerpt":{"rendered":"
                Introduction Airtable is a cloud-based platform that combines spreadsheet-style usability with relational data capabilities. Many teams use Airtable to manage projects, CRM pipelines, operations, and content workflows. To analyze this data at scale, you can connect Airtable to Power BI and build interactive reports. Using the ZappySys ODBC Driver for REST APIs, you can query […]<\/p>\n","protected":false},"author":5,"featured_media":12328,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[277,335],"tags":[637],"yoast_head":"\r\nHow to get data from Airtable into Power BI | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"How to get data from Airtable into Power BI - ZappySys Blog\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to get data from Airtable into Power BI | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"How to get data from Airtable into Power BI - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2026-07-09T16:23:00+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2026-07-22T14:10:08+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Airtable-logo.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"447\" \/>\r\n\t<meta property=\"og:image:height\" content=\"447\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys Team\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/\",\"url\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/\",\"name\":\"How to get data from Airtable into Power BI | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Airtable-logo.png\",\"datePublished\":\"2026-07-09T16:23:00+00:00\",\"dateModified\":\"2026-07-22T14:10:08+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"How to get data from Airtable into Power BI - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Airtable-logo.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Airtable-logo.png\",\"width\":447,\"height\":447},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to get data from Airtable into Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\",\"name\":\"ZappySys Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"caption\":\"ZappySys Team\"},\"sameAs\":[\"https:\/\/zappysys.com\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to get data from Airtable into Power BI | ZappySys Blog","description":"How to get data from Airtable into Power BI - ZappySys Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"How to get data from Airtable into Power BI | ZappySys Blog","og_description":"How to get data from Airtable into Power BI - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/","og_site_name":"ZappySys Blog","article_published_time":"2026-07-09T16:23:00+00:00","article_modified_time":"2026-07-22T14:10:08+00:00","og_image":[{"width":447,"height":447,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Airtable-logo.png","type":"image\/png"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/","url":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/","name":"How to get data from Airtable into Power BI | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Airtable-logo.png","datePublished":"2026-07-09T16:23:00+00:00","dateModified":"2026-07-22T14:10:08+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"How to get data from Airtable into Power BI - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Airtable-logo.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Airtable-logo.png","width":447,"height":447},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-airtable-into-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to get data from Airtable into Power BI"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e","name":"ZappySys Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","caption":"ZappySys Team"},"sameAs":["https:\/\/zappysys.com"],"url":"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12336"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=12336"}],"version-history":[{"count":5,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12336\/revisions"}],"predecessor-version":[{"id":12389,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12336\/revisions\/12389"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/12328"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=12336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=12336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=12336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}