question

ShainanHemrajani-5099 avatar image
0 Votes"
ShainanHemrajani-5099 asked ShainanHemrajani-5099 answered

Deploy Azure Analysis services with Azure db connection in Yaml Pipeline

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.

windows-server-powershellazure-sql-databaseazure-analysis-services
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ShainanHemrajani-5099 Thank you for posting your question.
AAD is not supported in Azure Analysis Service to connect Azure SQL Server when no user is involved. You have to use username and password.

Regards,
Oury

0 Votes 0 ·

Thanks @OuryBa-MSFT for the Response.

Can you direct to some documentation for setting this up. So basically deployment of AAS with Sql connections being updated.

0 Votes 0 ·

And also one more question does AAS try to connect to sql while deployment itself?
If not then can I not configure AAS to just use AAD while connecting to sql db. I would be doing my refreshes using ADF which has a identity assigned to sql db anyway.

0 Votes 0 ·

@ShainanHemrajani-5099 Please let us know if the answers provided below were helpful. Let us know if you need additional clarification.

Regards,
Oury

0 Votes 0 ·
LimitlessTechnology-2700 avatar image
0 Votes"
LimitlessTechnology-2700 answered

Hello @ShainanHemrajani-5099

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,

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered OuryBa-MSFT commented
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ShainanHemrajani-5099 Checking if you have additional questions. Please feel free to reach out if you do. If the above answer was helpful , please do mark as accepted answer for other community members facing the same.

Regards,
Oury

0 Votes 0 ·
ShainanHemrajani-5099 avatar image
0 Votes"
ShainanHemrajani-5099 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.