liprec / vsts-release-aas

Repository for my Analysis Service Azure pipelines tasks related to Azure Analysis Service or Power BI Premium
Other
27 stars 28 forks source link

Unable to use variable in the TMSL script. #29

Closed NimNagpal closed 3 years ago

NimNagpal commented 4 years ago

I have the below TMSL script where I want to pass variable for Database name and the member. This variable already exist in the release pipeline, but it doesn't allow me to use $(AASdbName) variable.

{ "createOrReplace": { "object": { "database": "AzureASDB", "role": "PowerBIEmbed_Role" }, "role": { "name": "PowerBIEmbed_Role", "description": "Reads custom information for Users.", "modelPermission": "read", "members": [ { "memberName": "", "identityProvider": "AzureAD" } ], "tablePermissions": [ { "name": "DIM_company", "filterExpression": "OR('DIM_company'[gcc_code_BK]=CUSTOMDATA(),OR('DIM_company'[gcc_code_BK]=\"ZCS\",'DIM_company'[gcc_code_BK]=\"ZZA\"))" } ] } } }

stale[bot] commented 3 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.