Nonprofit data solutions in Microsoft Fabric is a preconfigured, scalable data architecture and analytics accelerator that helps nonprofit organizations unify, transform, and analyze their data. It streamlines data management and delivers actionable insights so organizations can better understand constituents, optimize fundraising, and demonstrate impact.
The solution provides an end-to-end analytics foundation built on Microsoft Fabric:
| Folder | Description |
|---|---|
FabricWorkload/ |
A Microsoft Fabric Workload (WDK v2) that installs the full solution through a guided, in-product deployment wizard. |
Installation/ |
PowerShell automation to create, install, clean up, and manage the solution in a Fabric workspace without the workload UI. |
Migration/ |
A Fabric notebook that migrates installer item state from the Microsoft-released workload into this open-source workload. |
Docs/ |
Data model documentation — Gold and Silver ERDs (PDF), data dictionaries (CSV), and a solution overview. |
Additional capabilities will be added over time to support other nonprofit operations.
Fabric capacity — An F SKU (F4 or higher), Trial, or Premium capacity must be assigned to the target workspace. Deploying the solution provisions roughly 20+ Fabric items (Lakehouses, notebooks, pipelines, a semantic model, and a Power BI report).
Permissions — You need the Admin or Member role on the workspace to create items. To ingest from an external source, you also need credentials for that connector (Salesforce NPSP or Dynamics 365 / Common Data Model for Nonprofits). Sample data requires no external connection.
Cost — Fabric billing is consumption-based: you pay for the assigned capacity (compute) and the OneLake storage you use. Spark notebook runs and pipeline activity consume Capacity Units (CUs). Monitor usage with the Fabric Capacity Metrics app and see Fabric licensing for details.
You can deploy in two ways. We recommend the Fabric Workload for a faster, guided experience.
Install and run the solution through a guided wizard directly inside Microsoft Fabric.
See FabricWorkload/ for setup and run instructions.
Deploy with PowerShell automation if you prefer a scripted approach.
Prerequisites
fab)fab auth loginRun
cd Installation
./Install-IntoWorkspace.ps1 -WorkspaceName "MyWorkspace" -Prefix "NDS_"
See Installation/README.md for all scripts, parameters, and
data source options (sample data, Salesforce NPSP, and Dynamics 365 / Common Data Model for Nonprofits).
If you already run the Microsoft-released Nonprofit data solutions workload, the
Migration/ notebook copies your existing installer item state
(deployment history and selected modules) into a new open-source workload item so you don’t
have to reconfigure the installer from scratch. See
Migration/README.md for prerequisites and step-by-step usage.
This project welcomes contributions. See the repository CONTRIBUTING guide and Code of Conduct.
This project may contain trademarks or logos for projects, products, or services. Authorized use of Microsoft trademarks or logos is subject to and must follow Microsoft’s Trademark & Brand Guidelines. Use of Microsoft trademarks or logos in modified versions of this project must not cause confusion or imply Microsoft sponsorship.