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)

July 15, 2025 by Brian Kernan

In August 2025, Microsoft Fabric will introduce workspace access limits to improve service quality, reliability, and to encourage workspace access control hygiene. This limit will be permanent once it is rolled out – each Fabric & Power BI workspace will be limited to a maximum of 1,000 users or groups in workspaces roles (Admin, Member, … Continue reading “Introduction of access limits in a Fabric workspace”

July 15, 2025 by Dipti Borkar

We are thrilled to announce the general availability of Mirroring for Azure Databricks Unity Catalog in Microsoft Fabric—a secure, high-performance integration that provides seamless access to Azure Databricks tables from Fabric. With Fabric and Azure Databricks, we are building the future of data platforms on a lakehouse foundation, powered by open data formats, full interoperability, … Continue reading “Unified by design: mirroring Azure Databricks Unity Catalog to Microsoft OneLake in Fabric (Generally Available)”