Microsoft Fabric Updates Blog

Microsoft Purview Data Loss Prevention policies for Fabric have been extended to SQL, KQL and Mirrored Databases (Preview)

Microsoft Purview’s Data Loss Prevention (DLP) policies for Fabric now supports Fabric SQL, KQL and Mirrored DBs!

Purview DLP policies help organizations to improve their data security posture and comply with governmental and industry regulations. Security teams use DLP policies to automatically detect upload of sensitive information to Microsoft 365 applications like SharePoint and Exchange, and to Fabric’s semantic models and lakehouses.


Detect and protect your Fabric structured data

KQL DBs in Microsoft Fabric enable real-time, interactive analytics that empower organizations to quickly query and gain insights from massive datasets.

Fabric Mirrored DBs offer an easy-to-use, end-to-end platform that fosters collaboration and openness by combining multiple solutions into one seamless environment built to support the open-source Delta Lake table format.

SQL databases provide robust, scalable, and secure data storage solutions that seamlessly integrate with analytics, data engineering, and AI workloads.

Using DLP policies, security admins will be able to define policies which will scan data uploaded to SQL DBs, KQL DBs or Mirrored DBs (including Snowflake, Azure and more). When sensitive data is detected, the policy can be configured to trigger an alert for the security team and surface a descriptive policy tip to data owners to take a risk remediation action.

DLP policy tip as is displayed in the Onelake Catalog in Fabric


With this update we’re allowing you a more comprehensive view of the detected sensitive information in your Fabric tenant, including all the items listed below, with more planned for the near future, so stay tuned:

  • SQL Database
  • KQL Database 
  • Mirrored Azure Cosmos DB 
  • Mirrored Azure DB for PostgreSQL 
  • Mirrored Azure SQL Database 
  • Mirrored Azure SQL Managed Instance 
  • Mirrored database 
  • Mirrored Snowflake 
  • Mirrored SQL Server Database  
  • Lakehouse (previously supported) 
  • Semantic model (previously supported) 

Note that for KQL DBs DLP support you will need to enable the OneLake sync within the item, as shown below, to allow the DB to sync with OneLake where DLP will scan the data and surface the results.

KQL Onelake Toggle Enabled

As a reminder, Purview Data Loss Prevention Policies are acquired through the Purview new pay-as-yougo billing and are subject to consenting to the new business model.

As always, we welcome your comments or any feedback you may have regarding data loss prevention in Fabric. For any suggestions, please fill out our feedback form.

Related blog posts

Microsoft Purview Data Loss Prevention policies for Fabric have been extended to SQL, KQL and Mirrored Databases (Preview)

April 17, 2025 by Andreas Bergstedt

In today’s ever-changing analytics landscape it can be difficult to plan out your next project or your enterprise analytics roadmap. Designed to optimize data infrastructure planning, the Microsoft Fabric SKU Estimator helps customers and partners to accurately estimate capacity requirements and select the most suitable SKU for their workloads, protecting users from under-provisioning and overcommitment. … Continue reading “Mastering SKU Estimations with the Microsoft Fabric SKU Estimator”

April 14, 2025 by Jonathan Garriss

We’re excited to unveil the Microsoft Fabric SKU estimator, now available in preview—an enhanced version of the previously introduced Microsoft Fabric Capacity Calculator. This advanced tool has been refined based on extensive user feedback to provide tailored capacity estimations for businesses. Designed to optimize data infrastructure planning, the Microsoft Fabric SKU Estimator helps customers and … Continue reading “Empowering businesses with smart capacity planning: Introducing the Microsoft Fabric SKU estimator (Preview)”