Asked by:
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.
All replies
-
-
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.
-
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.
-
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?