Knowledge Share - Error with: New Tabular database 'Matrix' is not using latest encryption schema...

[LudiaGuo]

When I tried to deploy the SSAS model to the Azure SSAS server, I encountered the following error:

"New Tabular database 'Matrix' is not using the latest encryption schema. Please run RemoveDiscontinuedFeatures command with EnsureProperEncryption option..."

This issue is related to encryption schema compatibility. You can find the official solution in the Microsoft documentation here:
🔗 Upgrade encryption schema in Analysis Services

Quick Fix

1. Make sure you can connect to your SSAS database using SQL Server Management Studio.

2. Create and run the following XMLA script in SSMS, replacing "Your DB Name" with your actual database ID:

<RemoveDiscontinuedFeatures xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" xmlns:ddl922="http://schemas.microsoft.com/analysisservices/2022/engine/922"> <DatabaseID>"Your DB Name"</DatabaseID> <ddl922:EnsureProperEncryption>true</ddl922:EnsureProperEncryption> </RemoveDiscontinuedFeatures>

This worked perfectly for me — sharing here in case it helps you too!