Availability of Microsoft Information Protection labels for Azure SQL native data classification
Published May 02 2022 11:42 PM 2,916 Views

We are happy to announce that Azure SQL database, SQL managed instance & Azure Synapse database now provides you with MIP (Microsoft Information Protection) integrated data classification solution. MIP sensitivity labels provide a simple way for your users to classify sensitive data across the org with uniform standards and provide end to end classification solutions. If you have created standard sensitivity labels in Microsoft 365 then you can leverage this new enhancement to propagate the labels to Azure SQL Database and then to other downstream applications like PowerBI. This new capability in SQL native classification enables you to authenticate to Microsoft 365 and fetch the sensitivity labels automatically which can then be applied to the critical columns in the database. In addition to this, downstream inheritance of protection labels in PowerBI helps ensure that sensitive data remains classified throughout its journey, from data source to point of consumption. This new capability is now available in Data Discovery & Classification section under Security in Azure SQL portal. 


Check out our documentation for detailed steps: 

SQL data discovery & classification: Data Discovery & Classification - Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse ... 


Other references: 

Microsoft compliance center: Microsoft 365 compliance center 

Create & publish MIP labels in Microsoft 365: Create and publish sensitivity labels - Microsoft 365 Compliance | Microsoft Docs 

Inheritance of sensitivity labels in PowerBI: Sensitivity label inheritance from data sources in Power BI - Power BI | Microsoft Docs 

Availability of MIP enhancement for on-prem SQL Server: SQL data classification now offers Microsoft Informaton Protection labels in SSMS - Microsoft Tech C... 


Version history
Last update:
‎May 02 2022 11:42 PM
Updated by: