Do Dynamic granular level data masking permissions applied to Azure SQL database table's columns propagate to the Analysis Services tabular model based upon that table?
For example:
a) I have a Table A in an Azure SQL database. Table A has the columns :: empno int not null primary key, ename varchar(50) not null, sal decimal(10,2), SSN varchar(16) NULL); Columns sal and SSN have the following mask MASKED WITH (FUNCTION = 'default()'). The table has dummy data.
b) These two masked columns have granular level permissions, so that only persons belonging to AD group named user_group1 can see their unmasked data
c) I have verified that only users belonging to user_group1 can see the unmasked values in these columns in Azure Data Studio, others cannot
d) As an administrator, I have created a Tabular model based upon this table, and have deployed it to the Azure Analysis service. All users in my organization have been given Reader access to the tabular model
My questions are:
1) Will all users other than the ones belonging to the user_group1 see the data masked in these two columns that are part of the tabular model?
2) How do I propagate these granular dynamic masking rules to the Tabular model based upon this table, so that only certain users can see certain unmasked columns whereas other can not?
Thanks.