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.
437 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,244 questions
0 comments
Accepted answer
  1. Lukas Yu -MSFT 5,816 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

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Darren Gosbell 1,466 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

    0 comments