Every Microsoft Fabric Feature, Explained
A living catalog of 97 Microsoft Fabric capabilities across 11 catalog tabs: what each is, when to use it, when to skip it, and its GA or preview month.
A technology-agnostic map of security for applications and data platforms: governance as the foundation, eleven domains grouped by the question each answers, and four lenses (compliance, AI, shared responsibility, workload) that cut across them.
Security for an application or a data platform sorts into one foundation (governance and risk), eleven domains grouped by the question each answers, and a few lenses (compliance, AI, shared responsibility, workload type) that apply to every domain. Categories give each safeguard one home and one owner; without them, a safeguard comes up in three meetings and belongs to nobody.
Scope
Technology-agnostic, for applications, warehouses, and analytics platforms alike. The grouping is my synthesis of NIST CSF 2.0, ISO/IEC 27001, the CIS Controls, and the Cloud Security Alliance matrices, as of October 2026.
Security on a project usually starts as a list: governance, identity, data access, data protection, DLP and privacy, application security, network, data governance, monitoring, secure development, compliance, AI, third parties. A list is a fine start and a poor finish. Items overlap (data protection, privacy, and compliance all claim encryption), leave gaps (nobody is asked who restores data after ransomware), and lack owners ("AI security" gets discussed and never done).
A useful category passes three tests: it answers one question, it has a natural owner, and its evidence looks alike (a configuration, a test result, a contract). Sorting the list by those tests produces three different kinds of category.
Think of a building: governance is the foundation that carries everything, the domains are rooms with a purpose and someone responsible, and the lenses are inspectors (fire, accessibility, electrical) who own no room but walk through all of them.
NIST's Cybersecurity Framework (CSF) 2.0 puts its Govern function "in the center of the wheel" because it informs every other function. It holds five things:
It comes first because every domain refers back to it. "Encrypt sensitive data" means nothing until someone has decided what counts as sensitive and who signs off on exceptions.
The "what good looks like" column doubles as a starting checklist.
| Domain | What it covers | What good looks like |
|---|---|---|
| Identity & access | Sign-in, multi-factor authentication (MFA), accounts for people and for software (service accounts, pipelines, AI agents), joiners and leavers | Every identity is known and owned; people use MFA; no software credential lives forever |
Identity gets its own group because every other domain assumes you know who is asking. On a data platform much of the traffic comes from software (pipelines, report refreshes), and when a report server queries data under one shared account, the logs show the account and per-person rules cannot apply.
| Domain | What it covers | What good looks like |
|---|---|---|
| Data access control | Who may read which tables, rows, and columns, wherever the data is queried | A person sees the same rows through every tool that can reach the data |
| Data protection & DLP | Classification-driven encryption, masking, keys, and data loss prevention (DLP: controls on the routes data can leave by) | Sensitive data is encrypted, masked outside production, and leaves only by approved routes |
| Privacy | Whether personal data may be used at all: purpose, lawful basis, minimisation, retention, people's rights | Every use of personal data has a stated purpose and an end date |
| Data governance & lifecycle | Ownership, cataloguing, lineage (where data came from and where it flows), quality, retention, deletion | Every dataset has an owner, and deletion reaches every copy |
Four domains, because each has a different owner: data engineers run access rules, the platform team runs encryption and keys, privacy and legal decide what use is allowed, and data owners make governance calls. Rule of thumb: governance decides (label, owner, retention), protection enforces (the encryption, masking, or deletion that runs). DLP watches the exits, so it sits with protection; privacy asks whether the use is allowed at all,, a risk NIST calls "closely related" to cybersecurity yet distinct enough to need its own owner.
| Domain | What it covers | What good looks like |
|---|---|---|
| Application & API | The running software: input handling, sessions, and an authorization check on every request | Every request is checked against what this user may do |
| Platform, network & infrastructure | Servers, cloud configuration, network exposure, patching | Exposed services and known-exploited flaws are fixed within a stated time |
| Secure development & supply chain | How software is built: code review, dependencies, build pipelines, secrets kept out of code | Everything deployed comes from reviewed code with known ingredients |
Think of these as the product, the factory, and the floor. On a data platform the "software" includes notebooks, transformation code, and report definitions, and they belong in the same factory controls as application code.
| Domain | What it covers | What good looks like |
|---|---|---|
| Monitoring, audit & incident response | Logs, detection, investigation, and a practised response | Every data access traces to a person; the team has rehearsed an incident |
| Resilience & recovery | Backups, restore tests, recovery targets, continuity plans | Restores meet the agreed time, from backups an attacker cannot delete |
Detection and recovery have different owners and different tests, which is also why "secure development, deployment, and resilience" splits: build pipelines and restore tests share neither.
| Domain | What it covers | What good looks like |
|---|---|---|
| Third-party risk | Cloud providers, software vendors, data partners, open-source and model providers: selection, contracts, monitoring, exit | Critical suppliers are known, watched, and replaceable |
CSF 2.0 gives supplier risk ten outcomes, from ranking suppliers by criticality to what happens "after the conclusion of a partnership". It earns its own group: Verizon's 2026 breach report found a third party involved in 48% of breaches.
A lens is a question asked of every domain. It adds requirements, never a new home for safeguards.
A regulation is met by safeguards that already live in the domains. Keep the list of obligations in the foundation and tag each safeguard with the rules it satisfies ("implement once and comply everywhere"). The list moves: the EU AI Act's high-risk obligations now apply from December 2027 and August 2028, and the tags move with it.
Mostly, AI adds new assets to existing domains. The Cloud Security Alliance's AI Controls Matrix has 247 control objectives; only the 13 in Model Security have no counterpart in the cloud catalog it extends. OWASP's fix for AI assistants that leak documents is "permission-aware vector and embedding stores", which is data access control under another name.
| AI concern | Home domain |
|---|---|
| An assistant retrieves documents the user may not see | Data access control |
| An agent acts with more rights than the person behind it | Identity & access |
| Training or reference data is tampered with | Data governance, third-party risk |
| Instructions hidden in content the model reads | Application & API |
| Staff paste data into personal AI tools | Data protection & DLP |
| AI policy and impact assessment | Foundation |
When you rent infrastructure, a platform, or finished software (IaaS, PaaS, SaaS), the provider takes over more of the domains as you move up that ladder. Some never move. As one major provider puts it, "for all cloud deployment types, you own your data and identities". In the 2024 attacks on Snowflake customers, Mandiant found no evidence of a breach of the provider's own environment and traced the incidents to stolen customer credentials on accounts without MFA. Mark each domain provider, customer, or shared, and review the customer side hardest.
Same eleven domains, different weight.
| Domain | Application | Data platform |
|---|---|---|
| Identity & access | High | Highest: many software identities |
| Data access control | Enforced in code | Highest: several tools query the same data |
| Data protection & DLP | Moderate | High: exports, extracts, copies |
| Privacy | Moderate | High: joining datasets can re-identify people |
| Data governance & lifecycle | Low | High: deletion must reach every copy |
| Application & API | Highest | Moderate |
| Platform & infrastructure | High | Moderate, often provider-run |
| Secure development | High | High: notebooks and pipelines are code |
| Third-party risk | Moderate | High: the platform is usually rented |
On a data platform, an access rule set in one tool does nothing for another tool reading the same files, so test it through every path. Copies open an exit route: IBM found that more than a third of 2024 breaches involved "shadow data", data outside IT's control.
"We passed the audit, so we are secure." An audit confirms that safeguards exist. NIST's assessment guide asks whether they are "implemented correctly, operating as intended, and producing the desired outcome". Verizon found organizations fully fixed only 26% of critical known-exploited vulnerabilities, a gap a documented patch process hides.
"The data is encrypted, so it is safe." Encryption at rest protects against stolen disks and direct access to storage. Anyone who signs in with valid credentials reads the data decrypted, which is why stolen credentials were enough in the Snowflake attacks.
"Hashed data is anonymous." Under GDPR Recital 26, data that can be linked back to a person with additional information is still personal data. A hashed customer ID stays personal while the lookup table exists.
"MFA covers our identities." MFA protects people. Pipelines, scheduled jobs, and AI agents sign in with keys and secrets, and OWASP lists long-lived secrets among the top risks for these non-human identities. They need an owner, an inventory entry, and a rotation date.
"We have backups, so we can recover." A backup that has never been restored is a hope. CISA's ransomware guide asks for "offline, encrypted backups" and regular tests of their availability and integrity, kept out of reach of an attacker with admin rights.
A living catalog of 97 Microsoft Fabric capabilities across 11 catalog tabs: what each is, when to use it, when to skip it, and its GA or preview month.
AI knowledge retrieval works best as a router: match each question type (lookup, meaning, connect-the-dots, whole-collection) to the right search method (keyword, hybrid, reranking, multi-step, graph) instead of defaulting to vector search for everything.
A structured rubric for assessing Microsoft Fabric operational maturity. Six domains, five levels, and an interactive dashboard that scores your deployment and builds a near-, medium-, and long-term roadmap.