Migrate Ssas cubes to azure Analysis Services

simmigang 41 Reputation points
2021-04-12T19:13:05.91+00:00

Hi Everyone,

I need to migrate Ssas multi dimensional cubes to Azure Analysis services. Do I need to convert to Tabular models before migrating ? Please guide me the best way to migrate to Azure Analysis Services

Thank you

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
338 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,006 questions
No comments
{count} votes

Accepted answer
  1. Lukas Yu -MSFT 5,796 Reputation points
    2021-04-13T01:39:49.367+00:00

    Hi,

    Unfortunately, Multidimensional Cube is not supported in Azure Analysis Service.
    There is no direct way to "convert" the model type. You could have to reconstructure the project in Tabular model in SSAS. And I would suggest to do so as Tabular is better supported in Azure.

    Regards,
    Lukas

    No comments

1 additional answer

Sort by: Most helpful
  1. Darren Gosbell 1,456 Reputation points
    2021-04-12T22:53:43.943+00:00

    Azure Analysis Services only supports tabular models so if you want to use that you will need to rebuild your models using Tabular. The only option for multi-dim cubes on Azure is to run them in a VM running SQL Server Analysis Services

    No comments