Power BI for Charities

CHARITY ANALYTICS · POWER BI · 2026

Power BI is Microsoft’s data analytics tool. For UK charities it does one job very well: it takes the data you already collect — in Charitylog, Lamplight, Beacon, Salesforce, spreadsheets, your finance system — and turns it into live, shareable dashboards without requiring you to replace anything. Quematics builds Power BI environments for UK charities and VCSE organisations, with a specific focus on outcomes, impact, and commissioner-ready evidence rather than donor and fundraising reporting alone.

Most content about Power BI for charities is written for a fundraising audience: donor segmentation, campaign performance, volunteer hours. That work matters. But it is not what is putting pressure on charity leaders in 2026. What is putting pressure on them is the shift in what funders, commissioners, and regulators now expect — evidenced outcomes, equity analysis, prevented escalation, and an impact narrative that stands up to scrutiny.

This page covers Power BI from that angle: what it actually is, what it genuinely costs a UK charity in 2026 (including the licensing changes that caught a lot of organisations out), what it is good at, what it is bad at, when it is worth doing, and — importantly — when it is not.

What Power BI actually is, in plain English

Power BI is a tool that connects to your existing systems, pulls data out of them on a schedule you set, and presents it as interactive dashboards people can open in a web browser. Nobody has to change how they work. Your delivery team keeps recording sessions in Charitylog. Your finance team keeps working in Xero. Power BI reads from both and produces a single view that is current as of the last refresh — typically daily.

It comes in three parts, and the distinction matters when you start looking at cost:

•  Power BI Desktop — the Windows application where dashboards are actually built. Free for anyone, charity or not. This is where the work happens.
•  Power BI Service — the cloud platform where finished dashboards are published, shared, refreshed automatically, and secured with role-based access. This is the part that requires a paid licence for most sharing scenarios.
•  Power BI Mobile — apps for phone and tablet. Useful for trustees and senior staff who want a glance rather than a working session.

The single most common misunderstanding we encounter: Power BI is not a case management system and it does not collect data. It reads data that already exists somewhere else. If your charity does not yet record outcome scores anywhere, Power BI cannot conjure them. The collection discipline comes first; the dashboard makes it visible.

What Power BI actually costs a UK charity in 2026

This is the section most pages skip or get wrong, and it is worth getting right because the position changed materially in 2025.

On 1 July 2025 Microsoft discontinued two nonprofit grants: the Microsoft 365 Business Premium grant and the Office 365 E1 grant. Charities holding those licences kept them until their next renewal date after that point, then had to move to an alternative. Microsoft 365 Business Basic remains granted free for up to 300 users, but only for paid employees and executive staff — not volunteers or trustees.

Power BI itself was never free for charities. It is discounted, and the discount is substantial, but it is a discount rather than a grant. Nonprofit pricing also rose on the same date. Current published rates:

Two practical implications worth understanding.

You do not need a Pro licence for everyone. A common and entirely legitimate setup is a small number of Pro licences for the people who build and publish dashboards, with everyone else viewing through a shared workspace. How many you need depends on the sharing model, and getting this right is often the difference between a licence cost that is trivial and one that is uncomfortable.

If you already hold Microsoft 365 E5 or Office 365 E5, Power BI Pro is included. Some larger charities are already paying for Power BI without realising it.

What about the move to Microsoft Fabric?

Microsoft is gradually folding Power BI into a wider platform called Fabric, with a phased transition running through 2025 and 2026 depending on your agreement type and renewal cycle. Two things worth knowing: existing reports will not break, and the Power BI Pro per-user licence is not being retired. For the overwhelming majority of UK charities, this is a background change rather than something requiring action. The organisations affected are those on Premium capacity agreements, which is a small minority of the charity sector.

When Power BI is genuinely not the right answer

We would rather tell you this now than three months into a project.

If your charity has income under about £100,000 and runs a single programme, you almost certainly do not need Power BI. A well-structured spreadsheet — one row per client, consistent columns, an outcome score at start and end — will produce everything a funder asks for and everything your trustees need. Add a simple pivot table and a couple of charts and you have a perfectly credible reporting system that costs nothing and that one person can maintain. If that describes you, spend your energy on the measurement discipline (choosing a validated tool, capturing baselines consistently) rather than on analytics software. The discipline is what creates the evidence. The dashboard just displays it.

If you do not yet have a theory of change or a settled set of outcomes, a dashboard will surface numbers that raise more questions than they answer. Do that work first.

If your data collection is inconsistent — outcome scores captured for some clients and not others, different staff recording things differently, no agreed definitions — Power BI will make the inconsistency visible very quickly, which is useful, but it will not fix it. Data quality work comes first.

If nobody will own it, do not build it. Dashboards need a person. Data connections drift, funder requirements change, staff leave. A dashboard with no owner degrades within a year.

Power BI starts genuinely earning its keep when you have more than one programme, more than one funder, or more than a few hundred clients a year — the point at which manual reporting stops being a morning’s work and starts being a recurring multi-day burden.

What Power BI is genuinely good at for charities

Setting aside the donor and fundraising use cases every other page covers, here is where we see Power BI earn its place in UK charities and VCSE organisations.

Outcome measurement at scale. Matching baseline and follow-up scores at client level, applying reliable-change thresholds automatically (3 points on WEMWBS, 5 on PHQ-9, 4 on GAD-7, 3 on SDQ Total Difficulties), and producing an outcome rate by programme, cohort, and period. What takes a data officer a full day at quarter-end becomes a live view. This connects directly to the work covered on our charity impact dashboards page.

Equity and reach analysis. Converting client postcodes to Index of Multiple Deprivation deciles automatically, then segmenting outcomes by deprivation, protected characteristic, and geography. This is the analysis ICB commissioners and larger funders increasingly expect, and it is close to impossible to maintain manually.

Multi-funder reporting from one dataset. If you hold contracts with an NHS Integrated Care Board, a local authority, and a combined authority, each wants the same underlying activity presented in a different framework. Power BI lets you capture once and report to everyone — the problem we set out in When Your VCSE Holds Contracts With the NHS, Local Authority and Combined Authority at the Same Time.

Cost per outcome and value for money. Joining finance data to delivery data so you can state what an outcome actually costs. Increasingly asked for, rarely available.

The SORP 2026 trustees’ report impact narrative. Since accounting periods beginning on or after 1 January 2026, an evidenced impact narrative is mandatory. A dashboard turns that from a year-end scramble into a print-ready view. Covered fully in SORP 2026 & Impact Reporting.

Board and governance packs. The same underlying data presented as trustee assurance rather than operational detail — produced in minutes rather than assembled over days.

What Power BI is bad at

An honest list, because knowing the limits saves money.

•  It does not collect data. No forms, no case notes, no client records. It reads what exists elsewhere.
•  It is not a substitute for a case management system. If you are running services on spreadsheets and email, the answer may be a case management system first and Power BI second.
•  It handles qualitative data poorly. Case-study quotes, free-text feedback, and narrative evidence still need human curation. Power BI can count and categorise; it cannot tell the story.
•  It has a real learning curve. The data modelling layer (relationships between tables) and the DAX formula language are where most self-taught charity users get stuck. Building something that looks good is easy; building something that stays correct as data grows is not.
•  It rewards clean data and punishes messy data. Inconsistent client identifiers, duplicate records, and free-text where a dropdown should be will all surface as problems.

Power BI compared with the alternatives

Power BI is one option among several, and it is not automatically right. A fair comparison:

Excel or Google Sheets. Genuinely fine for small, single-programme charities. Free, universally understood, no learning curve. Breaks down when you have multiple data sources, multiple funders, or need the same numbers refreshed regularly.

Looker Studio (formerly Google Data Studio). Free, browser-based, easier to learn. Weaker at complex data modelling and at connecting to the UK charity systems you are likely running. A reasonable first step for a charity already in Google Workspace.

Tableau. Excellent visualisation, arguably better than Power BI at exploratory analysis. More expensive, and its nonprofit programme has changed over time. Now part of Salesforce.

Purpose-built impact platforms such as Makerble, Plinth, or the impact modules within case management systems. These combine data collection and reporting in one product, which is genuinely simpler if you are starting from nothing. The trade-off is that you are working within their outcome framework rather than your own, and getting your data out in a commissioner’s required format can be harder than it looks. Worth serious consideration for smaller charities; less suitable when you report to several commissioners in different formats.

Salesforce Nonprofit Cloud / NPSP. A CRM with reporting attached rather than an analytics platform. Powerful, but implementation cost and complexity are significant, and Salesforce has been directing new development toward its newer nonprofit products.

Where Power BI wins for the charities we work with: it sits on top of whatever you already have rather than replacing it, the nonprofit pricing is the lowest of the serious options, it connects to the UK charity and NHS systems that matter, and it produces output in whatever format a specific commissioner demands rather than one house format.

The systems we connect Power BI to

Power BI is deliberately system-agnostic. Typical connections in a UK charity build:

•  Charity and VCSE case management: Charitylog, Lamplight, Beacon, Salesforce Nonprofit Cloud (NPSP), Access Assemble, Views, Inform.
•  Clinical systems: SystmOne, EMIS, IAPTus — where services are delivered under an NHS contract or in an NHS-integrated setting.
•  Local authority systems: Mosaic, LiquidLogic, CareDirector, Controcc — usually via read-only reporting extracts agreed with the commissioner.
•  Fundraising and CRM: Blackbaud (Raiser’s Edge, eTapestry), Donorfy, DonorPerfect.
•  Finance: Xero, QuickBooks, Sage — where cost per outcome or value-for-money analysis is required.
•  Survey and outcome tools: SmartSurvey, Alchemer, Qualtrics, and the scoring exports from Outcomes Star, WEMWBS, PHQ-9, and GAD-7.
•  Spreadsheets: structured Excel and Google Sheets remain perfectly acceptable inputs.

If a system exports CSV, we can almost always connect to it. The technical detail of running several of these at once is covered in How Quematics Manages Multi-Framework VCSE Reporting.

What a charity Power BI build actually involves

Five stages. The timings are typical; a small charity with clean data moves faster, a multi-service charity with several systems takes longer.

1.  Data and evidence audit (2 to 3 weeks). What data you hold, where it lives, what condition it is in, and which validated outcome measures fit what you are trying to change. Deliberately unhurried, because the methodology fixed here determines every number the dashboard later produces.

2.  Theory of change alignment (1 to 2 weeks, only if needed). Skipped entirely if you already have a settled theory of change.

3.  Build (4 to 6 weeks). Connections, data model, outcome calculations, reliable-change scoring, equity segmentation, and audience-specific views for trustees, funders, and commissioners.

4.  Test and refine (1 to 2 weeks). Reconciling dashboard figures against your existing manual reports until they agree, which is the point at which people start trusting the numbers.

5.  Training and handover (1 to 2 weeks). Written documentation of every calculation, so the methodology is defensible to an auditor and maintainable by your team — or an ongoing managed-service arrangement if you would rather we kept it running.

We also help every client apply for Microsoft nonprofit pricing as part of setup, which is straightforward but easy to overlook.

Related reading

Impact and reporting

• Charity Impact Dashboards and Reports
• SORP 2026 & Impact Reporting: What Every Charity Must Now Do
• What Is Data Analytics for Charities? The Definitive 2026 Guide
• AI for Charities: Where We Are in 2026 and Why Data Is the Key
• The Five Reporting Burdens Facing Funded VCSEs in 2026
• The Leader’s Roadmap to 2026

Multi-commissioner reporting

• When Your VCSE Holds Contracts With the NHS, Local Authority and Combined Authority at the Same Time
• Three Different Frameworks, Three Different Reports
• One Data Layer, Multiple Commissioners

Social value and procurement

• The Procurement Act 2023 and Your VCSE Contract
• Social Value Analytics for VCSEs

Related services

• Charity Analytics
• Commissioner-Ready Reporting for Charities
• VCSE Commissioning Analytics
• Power BI Consultancy

Frequently asked questions

What is Power BI?

Power BI is Microsoft’s data analytics tool. It connects to systems you already use — case management software, spreadsheets, survey platforms, finance systems — pulls data from them on a schedule you set, and presents it as interactive dashboards people can open in a web browser. It comes in three parts: Power BI Desktop (where dashboards are built, free for everyone), Power BI Service (the cloud platform where they are published and shared, which requires a paid licence for most sharing), and Power BI Mobile. It reads data rather than collecting it, so it sits on top of your existing systems rather than replacing them.

Is Power BI free for charities?

Power BI Desktop is free, but it is free for everyone — it is not a charity concession. Power BI Pro, which you need to publish and share dashboards, is discounted for eligible nonprofits at around $4.20 per user per month on an annual commitment, compared with roughly £11 per user per month commercially. That is a substantial discount but it is not free. Separately, on 1 July 2025 Microsoft discontinued its Microsoft 365 Business Premium and Office 365 E1 nonprofit grants, so some charities that previously had free licences no longer do.

What changed with Microsoft nonprofit licensing in July 2025?

Two things. First, Microsoft discontinued the Microsoft 365 Business Premium grant and the Office 365 E1 grant for nonprofits — organisations holding those licences kept them until their next renewal after 1 July 2025, then had to move to an alternative. Microsoft 365 Business Basic remains granted free for up to 300 users, but only for paid employees and executive staff. Second, nonprofit pricing rose on Power BI: Pro went from $3.60 to $4.20 per user per month, and Premium Per User from $8.00 to $9.60, on annual commitment. Rates remain heavily discounted against commercial pricing.

How many Power BI Pro licences does our charity need?

Fewer than most people assume. A common setup is a small number of Pro licences for the people who build and publish dashboards, with other staff viewing through a shared workspace. The exact number depends on your sharing model and how many people need to interact with rather than just view reports. Getting this right is often the difference between a licence cost that is trivial and one that is uncomfortable, and it is worth working through properly before you buy. If you already hold Microsoft 365 E5 or Office 365 E5, Power BI Pro is already included.

Does our charity actually need Power BI?

Not necessarily. If your income is under about £100,000 and you run a single programme, a well-structured spreadsheet with one row per client, consistent columns, and an outcome score at start and end will produce everything a funder asks for. Add a pivot table and a couple of charts and you have a credible reporting system that costs nothing. Power BI starts genuinely earning its keep when you have more than one programme, more than one funder, or more than a few hundred clients a year — the point at which manual reporting stops being a morning’s work and becomes a recurring multi-day burden.

Is Power BI too difficult for a small charity to use?

Building something that looks good is straightforward. Building something that stays correct as data grows is harder. The two places self-taught users get stuck are the data modelling layer — defining relationships between tables so figures do not double-count — and DAX, the formula language used for calculations. Viewing and filtering a dashboard someone else has built requires no technical skill at all. So the honest answer is that using Power BI is easy, and building it robustly is a specialist job. Many charities get the best of both by having a dashboard built properly and then maintaining it in-house with documentation.

Can Power BI connect to Charitylog, Lamplight, or Beacon?

Yes. Charitylog, Lamplight, Beacon, and Salesforce Nonprofit Cloud (NPSP) are the systems we connect to most often. We also integrate with SystmOne and EMIS for NHS-delivered services, Mosaic, LiquidLogic, CareDirector and Controcc for local-authority reporting, Blackbaud and Donorfy for fundraising, Xero, QuickBooks and Sage for finance, and structured Excel or Google Sheets. If a system exports CSV, we can almost always connect to it.

Will Power BI replace our case management system?

No, and it should not. Power BI does not collect data — it has no forms, no case notes, no client records. It reads data that already exists in your case management system and presents it. Your delivery team keeps working exactly as they do now. If you are currently running services on spreadsheets and email with no case management system at all, the right sequence may be a case management system first and Power BI second.

What is Microsoft Fabric and does it affect us?

Fabric is Microsoft’s wider data platform, into which Power BI is gradually being folded, with a phased transition running through 2025 and 2026 depending on your agreement type and renewal cycle. For most UK charities this is a background change requiring no action: existing reports will not break, and the Power BI Pro per-user licence is not being retired. The organisations genuinely affected are those on Premium capacity agreements, which is a small minority of the charity sector.

How is Power BI different from Excel?

Excel is excellent at working with one dataset that one person maintains. Power BI is built for combining several data sources, refreshing them automatically, and sharing the result with people who should see different slices of it. The practical difference shows up in maintenance: an Excel reporting pack has to be rebuilt every reporting cycle, whereas a Power BI dashboard refreshes itself. For a single-programme charity, Excel is genuinely sufficient. For a charity reporting to three funders in three formats, Excel becomes the bottleneck.

How does Power BI compare with Tableau or Looker Studio?

Tableau is arguably better at exploratory visual analysis, but costs more and is now part of Salesforce. Looker Studio is free and easier to learn but weaker at complex data modelling and at connecting to the UK charity systems you are likely running — a reasonable first step for a charity already in Google Workspace. Power BI tends to win for UK charities on three counts: nonprofit pricing is the lowest of the serious options, it connects well to UK charity and NHS systems, and it handles the data modelling that outcome measurement actually requires.

How does Power BI compare with purpose-built charity impact platforms?

Platforms such as Makerble or Plinth combine data collection and reporting in one product, which is genuinely simpler if you are starting from nothing and helpful for charities without an existing case management system. The trade-off is that you work within their outcome framework rather than your own, and extracting data in a specific commissioner’s required format can be harder than expected. They are worth serious consideration for smaller charities. Power BI tends to suit organisations that already have systems they are keeping and that report to several commissioners in different formats.

Can Power BI produce our SORP 2026 impact narrative?

It can produce the evidence base for it. SORP 2026 requires an impact narrative in the trustees’ annual report for accounting periods beginning on or after 1 January 2026, set out in Module 1 paragraphs 1.27 to 1.33, with Tier 2 and Tier 3 charities required to explain the impact being made and consider long-term effect. A dashboard produces those figures as a print-ready view, current as at the balance sheet date and comparable year on year. The narrative writing itself is still a human job — the dashboard removes the year-end scramble to assemble the numbers.

How does Power BI handle equity and deprivation reporting?

Client postcodes captured at intake are converted automatically to Index of Multiple Deprivation deciles, which rank every small area in the UK from 1 (most deprived 10%) to 10 (least deprived 10%). Outcomes can then be segmented by deprivation decile, protected characteristic, and geography. Commissioners typically want to see what proportion of clients live in IMD deciles 1 to 3. This analysis is close to impossible to maintain manually and is one of the clearest cases for automating it.

Can Power BI calculate reliable change on outcome measures?

Yes, and this is one of the highest-value things it does. Baseline and follow-up scores are matched at client level and each tool’s published reliable-change threshold is applied automatically — 3 points on WEMWBS (1 on the shorter SWEMWBS), 5 on PHQ-9, 4 on GAD-7, 3 on SDQ Total Difficulties. That produces a defensible “proportion of clients who reliably improved” figure, which is materially stronger evidence than an average score change.

Is Power BI secure enough for NHS and local authority data?

Power BI runs on Microsoft Azure with UK-region hosting available, role-based access control, row-level security, and audit logging — the standards NHS commissioners and local authorities generally require at bid stage. That said, security is a whole-system question, not a tool question: you also need a documented retention policy, a Data Sharing Agreement with any commissioner receiving client data, and a Data Protection Impact Assessment where you work with vulnerable people. Many commissioners now also ask about Cyber Essentials certification.

How long does a charity Power BI build take?

A single-programme dashboard for a small charity typically takes 6 to 8 weeks end to end. A multi-programme dashboard covering three or four funders takes 10 to 14 weeks. The build itself is 4 to 6 weeks; the rest is the data and evidence audit at the start, testing and reconciliation, and training and handover at the end. Where there is a hard deadline — a commissioner reporting date or a SORP-compliant year-end — a foundation dashboard can be delivered faster and extended afterwards.

Who maintains the dashboard after it is built?

Either your team or ours. Data connections drift, funder requirements change, and staff move on, so a dashboard needs a named owner regardless of who that is. We provide written documentation of every calculation so the methodology is defensible and maintainable in-house, or we host and evolve the dashboard on an ongoing basis if you would rather not carry that internally. What does not work is building a dashboard with nobody responsible for it — those degrade within about a year.

What data do we need before we can start?

At minimum: a consistent client record (who), a record of what was delivered and when, and an outcome measure captured at least twice per client — a baseline and a follow-up. Postcode at intake is worth adding because it unlocks deprivation analysis for free. If you have those, you have enough to build something useful. If outcome scores are missing entirely, that is a measurement problem to solve before a dashboard is worth building.

Can trustees and funders view the dashboard directly?

Yes, with a few options. Internal viewers can be given access through your Power BI workspace with row-level security controlling what each person sees. External stakeholders such as funders can be given a filtered view, sent a scheduled PDF or PowerPoint export, or shown a published page embedded on your own website. Some charities publish a public-facing impact dashboard on their website; Ellen MacArthur Cancer Trust is a well-known UK example.

What is DAX and do we need to learn it?

DAX (Data Analysis Expressions) is the formula language Power BI uses for calculations — conceptually similar to Excel formulas but designed for relational data. It is where most self-taught users get stuck, particularly around how calculations behave when filters are applied. You do not need DAX to view or filter a dashboard, and you do not need it for basic edits. You do need it to build robust outcome calculations from scratch, which is a large part of why charities engage a specialist for the build and then maintain in-house afterwards.

Can we start small and expand later?

Yes, and that is usually the sensible route. A foundation dashboard covering one programme and one funder proves the approach, gets your team comfortable, and produces something useful quickly. Additional programmes, funders, and analysis layers are then added incrementally. Starting with an all-encompassing build tends to take longer to deliver anything useful and is harder to get adopted.

What are the most common mistakes charities make with Power BI?

Four recur. Building the dashboard before agreeing what the organisation is actually trying to measure. Connecting to messy data and expecting the tool to clean it. Buying Pro licences for everyone when only a few people need them. And building something with no named owner, so it quietly stops being refreshed. All four are avoidable, and all four are more common than technical problems.

Do you help with the Microsoft nonprofit application?

Yes, as part of project setup. Eligibility for Microsoft’s nonprofit programme is broad and most UK registered charities qualify, but the validation process takes a few days and the discounted pricing is not applied automatically — it has to be requested. It is straightforward and easy to overlook, and it is worth doing before any licences are purchased at commercial rates.

What is Power BI bad at?

Five things worth knowing. It does not collect data, so it cannot replace a case management system. It handles qualitative data poorly: case-study quotes and narrative evidence still need human curation. It has a real learning curve at the data modelling and DAX layers. It rewards clean data and punishes messy data, surfacing inconsistent identifiers and duplicates as problems. And it needs a named owner, because dashboards with nobody responsible for them degrade within about a year.

Book a free data and reporting review