Forum Discussion
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...
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