Deploy Azure Analysis services with Azure db connection in Yaml Pipeline

Question

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.

Answer 1

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,

Answer 2

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

Answer 3

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.