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

  • 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.

    Friday, May 10, 2019 5:56 AM

All replies

  • 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?

    Monday, May 13, 2019 4:59 PM
  • 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.

    Tuesday, May 14, 2019 3:06 AM
  • 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.

    Tuesday, May 14, 2019 4:31 AM
  • 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?

    Tuesday, May 14, 2019 11:27 AM