Easy Tech TutsHow to Connect GitHub to Power BI - Track Repos & Commits Easily 2026
By Impran M NLast checked against official docs
Power BI still has no GitHub button inside Get Data, but Microsoft does publish an official GitHub template app through AppSource that a lot of guides skip past. Point it at a repository and it builds a ready-made dashboard covering contributor activity, issue timing, and pull request counts, with almost no report-building required.
This guide installs that app first, then covers the custom Web-connector route for anyone who needs GitHub Enterprise support or data the template doesn't expose. Both paths authenticate with a GitHub personal access token instead of an OAuth prompt inside Power BI.
01Start from your Power BI workspace
Everything begins in My workspace, the default landing page in the Power BI service. Reports, semantic models, and dashboards are listed here by name, type, owner, and last refresh time. This is also where the GitHub-fed report will live once it's built, alongside anything else your workspace already has.
02Install the official GitHub template app
Open Apps from the workspace's left navigation. This opens Power BI's AppSource marketplace, not a custom-connector picker, and Microsoft lists a GitHub template app there under that exact name.
Search for it, click Get it now, then Install. Power BI creates a new workspace holding a ready-made dashboard, report, and semantic model: commit activity by contributor, issue open-and-close times, and pull request counts, once you connect it to your own data.
The template doesn't support GitHub Enterprise Server or Enterprise Cloud. If that's what your repos run on, skip ahead to the custom Web-connector steps.
03Generate a GitHub personal access token
On github.com, go to Settings, then Developer settings, then Personal access tokens. GitHub recommends fine-grained tokens over the classic kind: you can scope one to a single repository with Contents set to Read-only, while a classic token's repo scope reaches every repository you can already access, personal and organizational alike.
For a repository owned by an organization, that org may need to approve a fine-grained token before it can read anything inside it. A classic token skips that approval step but keeps the wider reach. Paste whichever type you choose into the template app's Connect your data screen when it asks for authentication.
04Build a custom connection when the template isn't enough
The template app covers one repository's contributors, issues, and pull requests. For GitHub Enterprise, several repositories combined, or a metric the template doesn't expose, build the connection yourself instead.
In Power BI Desktop, use Get Data, choose Web, and point it at the GitHub REST API endpoint for the data you want. Paste your token into the HTTP request header, not the URL, so it isn't stored in a saved query or a shared file.
05Shape the JSON and build your visuals
GitHub's API returns nested JSON. Power Query needs a handful of Expand and Convert to Table steps to pull commit author, date, and message into their own columns.
Filter out bot commits and merge commits if they'd skew a contributor activity chart. From there, build what the template didn't already give you: a line chart of commits over time, or a table comparing repositories side by side.
06Publish and schedule a refresh
Publish the report to the workspace you started in, then set a scheduled refresh from the dataset's settings. GitHub's API applies rate limits per token, so an hourly refresh is plenty for most teams; anything tighter risks hitting those limits for no real benefit.
| Token type | Scope | Reach | Org approval needed |
|---|---|---|---|
| Fine-grained | Contents: Read on selected repositories | Only the repositories you choose | Yes, for organization-owned repos |
| Classic | repo scope | Every repository you can already access, personal and organizational | No |
Per GitHub's own token documentation, checked September 2026.
When it doesn't work
GitHub doesn't show up when searching Get Data
Why: Power BI has no dedicated GitHub connector in Get Data. The only Microsoft-built options are the GitHub template app in AppSource and a hand-built Web connection to the REST API.
Fix: Install the template app from Apps, or use Get Data, then Web, against the GitHub REST API instead.
Connect your data returns nothing for an organization's repository
Why: A fine-grained token needs the organization's approval before it can read an org-owned repo. Without it, the request comes back empty instead of showing an error.
Fix: Ask an org owner to approve the token under the organization's fine-grained token settings, or switch to a classic token with the repo scope.
The GitHub template app won't connect to your repositories at all
Why: The template app doesn't support GitHub Enterprise Server or Enterprise Cloud.
Fix: Build a custom Web connection to your Enterprise instance's API endpoint instead of using the template app.
Frequently asked questions
Does Power BI have a built-in GitHub connector?
Not in Get Data. Microsoft instead publishes a GitHub template app through AppSource, and a custom Web connection to GitHub's REST API covers anything that template doesn't.
Does the GitHub template app work with GitHub Enterprise?
No. It only supports github.com repositories. Enterprise Server and Enterprise Cloud need a custom Web connection instead.
What GitHub token permissions do I need?
A fine-grained token with Contents set to Read, scoped to the repository you're pulling from, or a classic token with the repo scope if you'd rather skip organization approval and accept broader access.
Can Power BI show data from more than one GitHub repository?
Yes, though the template app is built around one repository at a time. To combine several in one report, install it more than once into separate workspaces, or query multiple repos through a custom Web connection.
Is a paid GitHub plan required for this?
No. Basic repository and commit data is available through the GitHub API on free accounts, provided you have read access and a valid token.
Sources and last check
Click path and screens for the workspace and Apps marketplace come from a walkthrough recorded in July 2025. Re-checked in September 2026: GitHub's own documentation on personal access token scopes and organization approval was fetched and read directly. The GitHub template app's feature set, its single-repository scope, and its lack of GitHub Enterprise support were corroborated through Microsoft's AppSource listings and Power BI community documentation, since Microsoft's specific Learn article for it redirected to a general index instead of loading directly in this session. This pass added the template-app path entirely; the original draft jumped straight to a hand-built Web connection despite an official pre-built option existing.
About the author
Impran M N
I've been hooked on technology for as long as I can remember — especially the new tools and AI apps that seem to land every other week. Easy Tech Tuts is where I write up whatever I've just worked out: I do the task in the real product, record the screen, and turn it into the guide I wish I'd found first.
