Power BI Security

[mtaneja]

Hi All. 

Need help to implement security at at combination of row & column level (partial columns in a ROW).  Following is the sample data, First table contains data with Full Access role and second table contains data post secuirty with partial access role (secured columns in red). 

 Without security (Full Access role) – 

With security (Partial Access role) - 

We tried writing DAX with email ID's hardcoded and it worked but we are not able to implement DAX at role level. Following is th snipped of DAX. Also, while defining Roles we are not able to access measures in DAX.

if(userprincipalname() in{emailid1, emailid2..} && min(table[colsection])="Sample1", table[qtrcalculation])

Please help and let us know inc ase further details are required. 

[amitchandak]

@mtaneja , for RLS you can consider roles

With tbale having email and data access values filtering you dimension or table

[email]= userprincipalname()

For column/Measure you can consider OLS, but it may error when you do not have access

What is Object Level Security (OLS): https://youtu.be/u4seqaMuzM8

You can also consider this for measure

if(userprincipalname() in{emailid1, emailid2..} && min(table[colsection])="Sample1", [Measure], blank() )

Power BI- Row Level Security(RLS): Handle ALL, UserPrincipalName: https://youtu.be/KVLEnIUo4pc