Addition of Roles,members and Updation of connection string of TBM model

Question

Hello Team,

Is there any powershell command to update the connection string of the data source of the AAS TBM model and list of Roles/Members since the connection details and roles gets over written after publishing the ASPAC to the server.

We want to avoid manual intervention.

Answer 1

Hello Nandan,

Could you please provide some details on how you publish your model?

Is it generated from a lower environment like dev or staging and published to production where the roles and members are different?

Answer 2

Hello Kalyan,

Yes,the roles and members are different at different environments.

And we are publishing it via Devops Marektplace offering:Azure analysis service deployment which overrides the roles,connection details and members as per the one checked in TFS(which would contain dev environment details)

So I need to update it again as per prod details once the ASPAC is published.

Answer 3

Hello Nandan,

Thank you for clarifying.

To preserve role definitions over successive solution deployments, a best practice is to define roles in SQL Server Data Tools as an integral part of the model.

You can then use Powershell to define role memberships as a step in your deployment pipeline

Add-RoleMember -MemberName "foo\user1" -Database "DB1" -RoleName "myRole"

Could you please try this script and let us know if it helps you list the roles and members.

Answer 4

Hi Kalyan,

We are facing MFA issue while using our account as a credential in the above command.

So would like to execute the command based on a service principal that has admin access on AAS server.

And also what is the command to update the connection string of the data source?