Migrating Azure Analysis Services Tabular model to On-Prem

Question

Hello,

We have an Azure Analysis Services tabular model which is planned to be migrated to On-Premises server (SQL Server 2019 or 2022 most probably). Compatibility level of AAS is 1500. Can someone advise if this is possible and point me to any articles or references if any for migration.

Thanks

Answer 1

You need to verify that your on-premises SSAS server supports the same or higher compatibility level as the AAS model (1500 in this case). SQL Server 2019 and 2022 support compatibility level 1500.

Use the Tabular Model Scripting Language (TMSL) or SSMS to export the AAS model metadata as a JSON or .bim file.

You can also use SSDT or Visual Studio with the Analysis Services projects extension to open the exported .bim file.

Then update the connection strings and data source configurations if required (if your data sources are also moving on-premises) then deploy the model to the on-premises SSAS instance.

https://learn.microsoft.com/en-us/analysis-services/tabular-models/deploy-tabular-models-ssdt?view=asallproducts-allversions

https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver16

https://learn.microsoft.com/en-us/sql/analysis-services/install-windows/configure-analysis-services-instance?view=sql-server-ver16