Migrating Tabular model with compatibility level 1100 to Azure Analysis Services

Azure-Data-Guy 21 Reputation points

We are trying to migrate a tabular model with compatibility level 1100 to AAS. I understand from the documenteation that a model with compatibility level of 1200 or above can be migrated to AAS. For Compatibility level below 1200, can we take the following approach: Migrate model with compatibility level 1100 to SQL Server 2016, change the compatibility level to 1200 and then migrate to AAS? Or is there a simpler way for doing the migration?
Thanks in advance!

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,056 questions
No comments
{count} votes

Accepted answer
  1. CarrinWu-MSFT 6,806 Reputation points

    Hi @Azure-Data-Guy ,

    Thank you for your post.

    Do you save the SSAS solution? If yes, you could change the compatibility level and the deployment server in visual studio, and then deploy to AAS. Please noted that before you change the compatibility level, you should back up the solution, because the compatibility level cannot change back to lower level.

    Best regards,

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

1 additional answer

Sort by: Most helpful
  1. Nandan Hegde 22,201 Reputation points

    You can upgrade the compatibility using VS as mentioned in the below links: