Deploy Tabular model cube on Azure from Sql server DB

Naami.Ayman 331 Reputation points
2021-08-24T10:03:16+00:00

Hi,

I have an On Premise tabular model cube, with a SQL Server DB as a source, and I want to deploy in Azure Analysis Services.
Is there any possibility for it ?

Thank you!

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

Accepted answer
  1. CarrinWu-MSFT 6,866 Reputation points
    2021-08-25T01:54:35.367+00:00

    Hi @Naami.Ayman ,

    Welcome to Microsoft Q&A!

    Yes, you can move On-Premise model to AAS. If the data source (or one of the data sources) for your tabular model is an On-Premise database, you will need to use a gateway so that the Azure AS model can reach it during processing. Please refer to below link:
    Azure Analysis Services - moving models from on-premises to cloud
    Connecting to on-premises data sources with On-premises data gateway

    Best regards,
    Carrin


    If the answer is helpful, please click "Accept Answer" and upvote it.
    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.

    0 comments No comments

0 additional answers

Sort by: Most helpful