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)

June 5, 2025 by Yael Biss

As data volume and complexity soar, protecting sensitive information has become non-negotiable. With the latest enhancements to Purview Data Loss Prevention (DLP) Policies in Microsoft Fabric, organizations now have the power to proactively secure their data in Onelake. Whether you’re just getting started or looking to take your data governance to the next level, following … Continue reading “Secure Your Data from Day One: Best Practices for Success with Purview Data Loss Prevention (DLP) Policies in Microsoft Fabric”

May 29, 2025 by Sukhwant kaur

Step into the future of simplicity with Fabric CLI. The Fabric Command Line Interface (CLI) has arrived in preview, bringing with it a seamless way to create SQL databases for your projects. This guide will take you through the steps to get started, ensuring you can leverage the power of Fabric CLI with ease. Prerequisites Before … Continue reading “How to create a SQL database in Fabric using Fabric CLI”