Animal Protection Denmark (Dyrenes Beskyttelse) has spent over a century rescuing and rehoming animals, but until recently, its data landscape looked more like a patchwork shelter than a modern nonprofit. Case records were scattered across four separate systems, field inspectors lacked mobile access to critical history, and leadership could not answer basic questions like “How many animals did we help last month?” without a manual, three-day reporting slog. That changed when the organization turned to Microsoft Fabric, Copilot, and the Power Platform, stitching together a single source of truth that now powers daily decisions for 500 staff and volunteers.

The transformation, detailed in a Microsoft customer story published on June 30, 2026, marks one of the first comprehensive Fabric deployments in the European nonprofit sector. It pairs the data unification muscle of Fabric with Dynamics 365, Power BI, and AI-assisted workflows in Copilot, reshaping how one of Denmark’s oldest animal welfare charities delivers care.

A Data Dilemma Decades in the Making

Founded in 1875, Animal Protection Denmark operates 12 shelters, a wildlife station, and a network of volunteer-run branches. Its core mission—rescue, rehabilitation, and adoption—generates a torrent of information: intake forms, veterinary records, behavioral assessments, adoption applications, donor histories, and field inspector reports. By 2024, that data lived in a disjointed mix of legacy CRM, Excel spreadsheets, and paper binders.

“We had data everywhere and nowhere at the same time,” said CIO Mette Holm in the customer story. Inspectors in the field often arrived at cruelty cases with no background on prior complaints. Shelter managers manually tallied weekly intake on whiteboards. Fundraising teams could not segment donors by engagement history, leaving money on the table.

The technical debt was not just inconvenient—it was harming animals. When a German shepherd mix arrived at a rural shelter with a limp, staff had to fax a nearby vet for records that sat in a disconnected practice management system. The delay meant the dog’s treatable ligament tear worsened over 72 hours, a case that became a catalyst for change.

The Microsoft Fabric Core: OneLake as the Animal Data Hub

Animal Protection Denmark’s digital turnaround started with a bold bet: migrate all operational data into Microsoft OneLake, the unified data lake at the heart of Fabric. Working with Microsoft partner Compusoft, the team used Fabric’s data pipelines to ingest streams from Dynamics 365 Customer Insights (donor and adopter data), Dynamics 365 Business Central (finance), a custom Power Apps–based animal case management system, and even legacy spreadsheets via Fabric Data Factory.

Fabric’s shortcuts feature let them keep some historical data in Azure Blob Storage while querying it as if it lived in OneLake, avoiding costly migration of 15 years of archived records. Within eight weeks, 150,000 animal records, 40,000 donor profiles, and five years of financial transactions sat in Fabric, curated into a star schema with dimensions for species, location, outcome, and time.

“For the first time, we could see the complete journey of a single animal—from rescue call to adoption or release—in one place,” Holm noted. The lakehouse architecture meant data engineers used T-SQL notebooks for complex transformations while citizen analysts explored semantic models in Power BI, all within the same SaaS environment.

Power BI and Real-Time Dashboards

With data centralized, the organization built a suite of Power BI dashboards that now run on a scheduled refresh every 15 minutes. Shelter teams monitor live occupancy, medical milestones, and adoption pipeline velocity. Field inspectors see a tablet-friendly map of active cases, color-coded by urgency, pulling real-time data from Fabric’s SQL analytics endpoint.

One dashboard—the “Animal Intake & Outcomes” report—replaced a Monday morning ritual where managers manually compiled paper logs. Now, executive director Britta Riis can open the dashboard on her phone and see that the Jutland shelter has three available foster homes, that the cat adoption rate is trending 12% above last month, and that the wildlife station released 18 rehabilitated hedgehogs in the past week.

The impact is measurable. Adoption cycle time from intake to new home dropped 23% because staff can immediately identify animals that need minimal intervention and fast-track their placement. Veterinary cost per animal fell 9% through better inventory tracking and bulk purchasing insights surfaced in Business Central data.

Copilot: AI That Speaks Dog (and Cat, and Rabbit)

Perhaps the most striking innovation is the organization’s use of Microsoft Copilot in Fabric. The AI assistant, embedded directly in notebooks and the Power BI report canvas, lets shelter staff ask natural-language questions of their data without writing a line of DAX.

A shelter coordinator can type “Show me all dogs over 8 years old currently in foster care across North Jutland” and Copilot generates the appropriate T-SQL or MEASURE, surfaces the result as a visualization, and even suggests adding a filter for medical conditions. This capability, rolled out in Fabric’s June 2025 copilot update, has eliminated the bottleneck of relying on a two-person data team for ad hoc queries.

More profound is Copilot’s role in proactive animal welfare. The team built a Fabric Data Activator reflex that monitors new intake records. When a pattern matches known neglect indicators—say, multiple dogs from the same postal code arriving with similar malnutrition—Copilot drafts an alert via Teams, suggesting the field inspector schedule a follow-up visit. It cross-references historical case notes stored in Dynamics 365 using Fabric’s AI Skill, ensuring no subtle pattern goes unnoticed.

“Copilot doesn’t replace the inspector’s gut feeling,” said Holm. “But it makes sure their gut feeling is informed by 150,000 data points, not just the last five cases they remember.”

The Power Platform Connection: Custom Apps and Automation

While Fabric and Copilot handle analytics, the day-to-day operations run on a custom suite of Power Apps. The main “Case Manager” app, built on a Microsoft Dataverse backend that feeds directly into Fabric, lets inspectors file reports from the field, attach photos, and schedule follow-ups—all while offline. Upon sync, the data flows into OneLake within minutes.

A Power Automate flow watches for certain triggers: when an animal’s status changes to “ready for adoption,” it updates the public-facing website, posts to Facebook and Instagram via a custom connector, and creates a task in the adoption coordinator’s Planner board. Another flow reads Business Central vendor records and Fabric inventory data to auto-generate purchase orders for shelter supplies when stock falls below thresholds.

The tight integration with Dynamics 365 Customer Insights enriches donor segments using behavioral data from Fabric. For example, a donor who adopted a senior cat from the Roskilde shelter automatically receives a fundraising email featuring that specific shelter’s current senior pets—a personalization tactic that lifted donor conversion by 18% in the first quarter after launch.

Architecture That Scales

Under the hood, Animal Protection Denmark’s Fabric deployment uses a capacity on the F64 tier, provides enough compute for complex transformations and real-time dashboards without overprovisioning. The organization pays a flat monthly rate through its Microsoft nonprofit licensing, which includes significant discounts on Dynamics 365 and Power Platform.

Data security is paramount given sensitive donor and veterinary data. Fabric’s role-based access control limits visibility: veterinary staff see medical histories but not donor PII; fundraising teams see giving history but not adoption outcomes. All access is managed via Entra ID groups, with Microsoft Purview applied consistently across lakehouses, warehouses, and semantic models.

Compusoft’s lead architect on the project, Lars Midtgaard, noted that moving from a fragmented on-premise world to Fabric’s SaaS model eliminated the need for a dedicated ETL server and cut nightly batch processing from six hours to 22 minutes. “We used to patch SQL Server, monitor disk queues, and pray the Excel imports didn’t crash,” he said. “Now we spend that time actually improving animal outcomes.”

The Human Side of Data-First Care

Technology alone doesn’t save animals—people do. But the Fabric implementation has reshaped the organization’s culture around data. Every shelter morning meeting starts with a five-minute Power BI briefing. Field staff, initially skeptical about typing reports into a tablet, now routinely use Copilot to check on animals they’ve previously rescued, finding personal satisfaction in seeing “Adopted” statuses.

Even volunteers have access to a trimmed-down mobile dashboard showing upcoming shifts, foster animal vitals, and training videos—all surfaced from Fabric through an embed in a standalone Power App.

The organization’s 2025 annual report, generated entirely within Fabric using Power BI paginated reports, combined financials from Business Central, impact metrics from the lakehouse, and narrative from Copilot-driven summaries. It was released three weeks earlier than prior years and cost 40% less to produce, freeing staff to focus on winter rescue operations.

What This Means for Windows and Microsoft Enthusiasts

For the Windows-focused audience, this story underscores how deeply the Microsoft ecosystem now extends beyond OS and productivity into purpose-built vertical solutions. Animal Protection Denmark runs its custom Power Apps on iOS and Android devices, but all management, governance, and development occur through Windows-based tools: the Fabric portal in Microsoft Edge, Power BI Desktop, Visual Studio Code with Fabric extensions, and the Copilot pane in Windows 11’s sidebar.

The organization also benefits from Windows Autopatch and Intune, ensuring the 60-odd Windows 11 laptops used by field teams stay updated and secure without IT overhead. This quiet integration of OS, analytics, and AI is the very fabric—pun intended—of Microsoft’s current vision.

Lessons for Other Nonprofits

Animal Protection Denmark’s journey offers a replicable blueprint. The key decisions were:

  • Start with the animal (or beneficiary) record: By modeling all data around a single entity, the star schema unlocked cross-functional insights.
  • Use Fabric shortcuts aggressively: They avoided moving legacy data unnecessarily, saving time and cost.
  • Democratize AI with Copilot: Even non-technical staff now answer their own questions, reducing data team burnout.
  • Leverage Microsoft’s nonprofit program: Pricing that could have been prohibitive became affordable through eligible discounts.

Caveats remain. Real-time Copilot licensing requires careful capacity planning to avoid usage overruns. Data quality is a continuous battle—volunteers occasionally input “tuxedo cat” as a breed, something the data team handles with Fabric’s data wrangling features. And as the organization expands to support a national wildlife rehabilitation network, the Fabric lakehouse will need to accommodate sensor data from tracking collars and IoT scales, a frontier they’re already prototyping.

Looking Ahead

Animal Protection Denmark plans to add Fabric real-time intelligence streams for GPS-collared released wildlife, integrating with Azure IoT Hub. They’re also testing Copilot Studio to build a “virtual assistant” bot for adopters, answering questions about animal history directly from Fabric data.

“We’re not a tech company,” Holm said. “We’re an animal welfare organization that happens to have world-class data. And that world-class data lets us do what we do best: help more animals, faster, with fewer resources.”

In a sector often defined by shoestring budgets and burnout, Animal Protection Denmark’s Microsoft Fabric deployment shows that data-first care isn’t just a slogan—it’s a practical, executable strategy that puts paws on the path to forever homes.