{"id":12203,"date":"2026-06-05T12:05:37","date_gmt":"2026-06-05T12:05:37","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=12203"},"modified":"2026-06-05T12:06:36","modified_gmt":"2026-06-05T12:06:36","slug":"how-to-read-github-data-in-powerbi-using-odbc","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/how-to-read-github-data-in-powerbi-using-odbc\/","title":{"rendered":"How to read GitHub data in Power BI using ODBC"},"content":{"rendered":"

Introduction<\/h2>\n

\"GitHub\"<\/a>GitHub is a leading platform for source control, CI\/CD workflows, and team collaboration. Many organizations need GitHub data in Power BI to monitor engineering performance, repository health, pull request velocity, and issue resolution trends.<\/p>\n

Using ZappySys ODBC Driver for REST APIs, you can connect to GitHub and query GitHub data with SQL, then load it directly into Power BI dashboards without writing custom integration code.<\/p>\n

This tutorial shows how to create an ODBC DSN for the GitHub API, preview data, connect Power BI, and build analytics using custom SQL queries.<\/p>\n

<\/h3>\n

Prerequisites<\/h2>\n
    \n
  1. A GitHub account with access to target repositories or organisation data.<\/li>\n
  2. Power BI Desktop is installed on your machine.<\/li>\n
  3. Basic understanding of SQL and Power BI data modelling.<\/li>\n
  4. Finally, install the ZappySys ODBC Driver<\/a>.<\/li>\n<\/ol>\n

    Steps<\/h2>\n

    Create a GitHub Personal Access Token<\/h3>\n
      \n
    1. Sign in to your GitHub account<\/a>.<\/li>\n
    2. Go to Settings<\/strong>, then find the Developer settings<\/strong> at the bottom of the page.\n
    3. Now go to Personal access tokens<\/strong> and create a new token (fine-grained or classic, depending on your security policy).<\/li>\n
    4. Select permissions required for your extraction scenario (for example, repository metadata, issues, or pull requests), owner, expiration date and more.<\/li>\n
    5. Generate the token and copy it to a secure location.\n
      \"\"<\/a>

      Github – Generate a new token<\/p><\/div><\/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 the User DSN<\/strong> or System DSN<\/strong> tab, click Add<\/strong>.<\/li>\n
      3. Select ZappySys JSON Driver<\/strong> and click Continue<\/strong>.
        \n        \"\"<\/a><\/li>\n<\/ol>\n

        Configure the Connection and API Settings<\/h3>\n
          \n
        1. Enter the base URL:
          \nhttps:\/\/api.github.com\/user<\/span><\/span><\/li>\n
        2. In Connection Type<\/strong>, select HTTP<\/strong> and click Configure<\/strong>.<\/li>\n
        3. Select Static Token<\/strong>\/API Key<\/strong> as the\u00a0Credential type<\/strong>.<\/li>\n
        4. Paste your GitHub token in the authentication field.<\/li>\n
        5. Click OK<\/strong> to save the configuration.\n
        6. Set HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
        7. Set the following values in the HTTP headers<\/strong>:\n
            \n
          1. Accept: application\/vnd.github+json<\/li>\n
          2. X-GitHub-Api-Version: 2022-11-28<\/li>\n<\/ol>\n<\/li>\n
          3. Set JSON Path Filter<\/strong> to extract the object array.<\/li>\n
          4. Click Test Connection<\/strong> to verify connectivity, then click OK<\/strong> to save the DSN.\n
            \"\"<\/a>

            Github – ODBC configuration<\/p><\/div><\/li>\n<\/ol>\n

            Preview GitHub data in ODBC Driver<\/h3>\n
              \n
            1. Go to the Preview<\/strong> tab.<\/li>\n
            2. Generate a query, then click\u00a0Preview Data<\/strong> to confirm that rows are returned.<\/li>\n
            3. If no data is returned, verify your organisation name, token scope, and JSON Path Filter.\n
              \"\"<\/a>

              GitHub – ODBC result<\/p><\/div><\/li>\n<\/ol>\n

              Connect Power BI to GitHub via ODBC<\/h3>\n
                \n
              1. Open Power BI Desktop<\/strong>.<\/li>\n
              2. Click Get Data<\/strong> from the Home ribbon.<\/li>\n
              3. Click More…<\/strong>, search for ODBC<\/strong>, and click Connect<\/strong>.\n
              4. Select your GitHub ODBC DSN from the dropdown list.<\/li>\n
              5. Optionally, enter a custom SQL query in Advanced options<\/strong>.<\/li>\n
              6. Click OK<\/strong>, then click Load<\/strong> to import data.\n
              7. Verify the result and click Load<\/strong>.\n
              8. In the Navigator window, select the columns you want to load.\n
                \"\"<\/a>

                GitHub – Power BI final result<\/p><\/div><\/li>\n<\/ol>\n

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

                For advanced analytics, use custom SQL queries in Power BI or the ODBC tool.<\/p>\n

                Example 1: List Repositories<\/strong><\/p>\n

                SELECT \r\n    id,\r\n    name,\r\n    nameWithOwner,\r\n    isPrivate,\r\n    stargazerCount,\r\n    forkCount,\r\n    updatedAt\r\nFROM data.organization.repositories.nodes<\/pre>\n
                Example 2: Public Repositories Only<\/strong><\/p>\n
                SELECT \r\n    name,\r\n    nameWithOwner,\r\n    stargazerCount,\r\n    forkCount\r\nFROM data.organization.repositories.nodes\r\nWHERE isPrivate = false<\/pre>\n
                Example 3: Most Starred Repositories<\/strong><\/p>\n
                SELECT \r\n    nameWithOwner,\r\n    stargazerCount,\r\n    forkCount\r\nFROM data.organization.repositories.nodes\r\nORDER BY stargazerCount DESC<\/pre>\n
                Example 4: Recently Updated Repositories<\/strong><\/p>\n
                SELECT \r\n    nameWithOwner,\r\n    updatedAt,\r\n    createdAt\r\nFROM data.organization.repositories.nodes\r\nWHERE updatedAt >= DATEADD(DAY, -30, GETDATE())<\/pre>\n
                Example 5: Repository Count by Visibility<\/strong><\/p>\n
                SELECT \r\n    CASE WHEN isPrivate = true THEN 'Private' ELSE 'Public' END AS RepoVisibility,\r\n    COUNT(*) AS RepoCount\r\nFROM data.organization.repositories.nodes\r\nGROUP BY CASE WHEN isPrivate = true THEN 'Private' ELSE 'Public' END<\/pre>\n
                Example 6: Language-Based Distribution<\/strong><\/p>\n
                SELECT \r\n    primaryLanguage_name AS Language,\r\n    COUNT(*) AS RepoCount,\r\n    AVG(stargazerCount) AS AvgStars\r\nFROM data.organization.repositories.nodes\r\nGROUP BY primaryLanguage_name\r\nORDER BY RepoCount DESC<\/pre>\n
                Create Useful Power BI Measures<\/h3>\n
                Use DAX measures after loading the GitHub dataset:<\/p>\n
                Total Repositories<\/strong><\/p>\n
                TotalRepos = COUNTROWS('nodes')<\/pre>\n
                Total Stars<\/strong><\/p>\n
                TotalStars = SUM('nodes'[stargazerCount])<\/pre>\n
                Average Forks per Repository<\/strong><\/p>\n
                AvgForks = AVERAGE('nodes'[forkCount])<\/pre>\n
                Private Repository %<\/strong><\/p>\n
                PrivateRepoPct =\r\nDIVIDE(\r\n    CALCULATE(COUNTROWS('nodes'), 'nodes'[isPrivate] = TRUE()),\r\n    COUNTROWS('nodes')\r\n)<\/pre>\n
                Conclusion<\/h2>\n
                Connecting GitHub to Power BI using ZappySys ODBC Driver makes it easy to build engineering analytics without writing custom connector code. With SQL-based access to GitHub API responses, you can monitor repository activity, contribution trends, and governance metrics in one place.<\/p>\n
                Explore the full capabilities of the Zappysys ODBC Drivers<\/a> to integrate multiple data sources and build comprehensive Power BI dashboards. By combining GitHub data with other sources, you can create unified views of your operational data.<\/p>\n
                Need Help?<\/h2>\n
                If you encounter any issues, our support team is here to help:<\/p>\n
                  \n
                1. Live Chat<\/strong> \u2014 Use the chat widget (bottom-right corner of this page)<\/li>\n
                2. Email<\/strong> \u2014 support@zappysys.com<\/li>\n
                3. Support Center<\/strong> \u2014 Visit the ZappySys Support Portal<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
                  Introduction GitHub is a leading platform for source control, CI\/CD workflows, and team collaboration. Many organizations need GitHub data in Power BI to monitor engineering performance, repository health, pull request velocity, and issue resolution trends. Using ZappySys ODBC Driver for REST APIs, you can connect to GitHub and query GitHub data with SQL, then load […]<\/p>\n","protected":false},"author":5,"featured_media":12188,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"yoast_head":"\r\nHow to read GitHub data in Power BI using ODBC | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"How to read GitHub data in Power BI using ODBC - 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-read-github-data-in-powerbi-using-odbc\/\" \/>\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 read GitHub data in Power BI using ODBC | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"How to read GitHub data in Power BI using ODBC - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/how-to-read-github-data-in-powerbi-using-odbc\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2026-06-05T12:05:37+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2026-06-05T12:06:36+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Github-Go-to-Developer-settings.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"581\" \/>\r\n\t<meta property=\"og:image:height\" content=\"732\" \/>\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=\"6 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-read-github-data-in-powerbi-using-odbc\/\",\"url\":\"https:\/\/zappysys.com\/blog\/how-to-read-github-data-in-powerbi-using-odbc\/\",\"name\":\"How to read GitHub data in Power BI using ODBC | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-read-github-data-in-powerbi-using-odbc\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-read-github-data-in-powerbi-using-odbc\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Github-Go-to-Developer-settings.png\",\"datePublished\":\"2026-06-05T12:05:37+00:00\",\"dateModified\":\"2026-06-05T12:06:36+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"How to read GitHub data in Power BI using ODBC - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-read-github-data-in-powerbi-using-odbc\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/how-to-read-github-data-in-powerbi-using-odbc\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-read-github-data-in-powerbi-using-odbc\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Github-Go-to-Developer-settings.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Github-Go-to-Developer-settings.png\",\"width\":581,\"height\":732,\"caption\":\"Github - Go to Developer settings\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-read-github-data-in-powerbi-using-odbc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to read GitHub data in Power BI using ODBC\"}]},{\"@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 read GitHub data in Power BI using ODBC | ZappySys Blog","description":"How to read GitHub data in Power BI using ODBC - 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-read-github-data-in-powerbi-using-odbc\/","og_locale":"en_US","og_type":"article","og_title":"How to read GitHub data in Power BI using ODBC | ZappySys Blog","og_description":"How to read GitHub data in Power BI using ODBC - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/how-to-read-github-data-in-powerbi-using-odbc\/","og_site_name":"ZappySys Blog","article_published_time":"2026-06-05T12:05:37+00:00","article_modified_time":"2026-06-05T12:06:36+00:00","og_image":[{"width":581,"height":732,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Github-Go-to-Developer-settings.png","type":"image\/png"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/how-to-read-github-data-in-powerbi-using-odbc\/","url":"https:\/\/zappysys.com\/blog\/how-to-read-github-data-in-powerbi-using-odbc\/","name":"How to read GitHub data in Power BI using ODBC | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/how-to-read-github-data-in-powerbi-using-odbc\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/how-to-read-github-data-in-powerbi-using-odbc\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Github-Go-to-Developer-settings.png","datePublished":"2026-06-05T12:05:37+00:00","dateModified":"2026-06-05T12:06:36+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"How to read GitHub data in Power BI using ODBC - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/how-to-read-github-data-in-powerbi-using-odbc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/how-to-read-github-data-in-powerbi-using-odbc\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/how-to-read-github-data-in-powerbi-using-odbc\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Github-Go-to-Developer-settings.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Github-Go-to-Developer-settings.png","width":581,"height":732,"caption":"Github - Go to Developer settings"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/how-to-read-github-data-in-powerbi-using-odbc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to read GitHub data in Power BI using ODBC"}]},{"@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\/12203"}],"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=12203"}],"version-history":[{"count":4,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12203\/revisions"}],"predecessor-version":[{"id":12215,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12203\/revisions\/12215"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/12188"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=12203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=12203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=12203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}