Deploy Azure Analysis services with Azure db connection in Yaml Pipeline

Shainan Hemrajani 1 Reputation point
2021-09-10T09:41:00.727+00:00

Hi,
I am creating YAML pipelines for Automating Deployment. I am deploying AAS using Powershell and need to figure out ways of configuring azure database connections.
I do not have username/password set up for db, it is accessed by AAD. I would like to configure connection without using usernames, may be some Identity or Service Principal option.

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
437 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,355 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Limitless Technology 39,336 Reputation points
    2021-09-15T17:02:44.923+00:00

    Hello @Shainan Hemrajani

    AAS will not let you connect to a DB without user/password settings.

    Regarding the setup you can see more information here:
    https://azure.microsoft.com/es-es/blog/using-azure-analysis-services-over-azure-sql-db-and-dw/

    and how to create the first data model in AAS:
    https://azure.microsoft.com/es-mx/blog/first-azure-as/

    Hope this information helps with what you want to achieve,
    Best regards,

    0 comments
  2. Oury Ba-MSFT 16,076 Reputation points Microsoft Employee
    2021-09-19T03:32:22.987+00:00

    Hi @Shainan Hemrajani You need to create connections when deploying models and provide proper permissions while creating connections
    https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-deploy
    https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-datasource#tab1400b

    Regards,
    Oury

  3. Shainan Hemrajani 1 Reputation point
    2021-09-30T08:48:53.967+00:00

    Hi,
    I have cracked it.
    I am updating just sql servername and Path in model.bim file while deploying through Yaml pipeline.

    And I create a token and add in the credential part before refreshing the cube.
    The tokens are created by Automation account that has an identity attached to AAS.

    Thanks you all for responses.

    0 comments