Forum Discussion

mtaneja's avatar
mtaneja
New Member
2 years ago

Power BI Security

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. 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    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