Creating row level security using mutiple columns

[saktisahoo2006]

Hello,

I have a data file from Jira with the columns below.

Epic Link	Team Owner	Issue key	Issue id	Assignee	Issue Type	Original Requestor ID	L4 - AVP	L5 - VP	L6	L7	L8
Ep1	TW1	IS1	ISS!	abc	Story	id1@gmail.com	avp1@gmail.com	vp1@gmail.com	l1@gmail.com	l11@gmail.com	l45@gmail.com
Ep2	Tw2	IS2	ISS2	def	Story	id2@gmail.com	avp2@gmail.com	vp2@gmail.com	l2@gmail.com	l22@gmail.com	l67@gmail.com

Basically

"Original Requestor ID"  reports to > "L4 - AVP"  reports to > "L5 - VP"  reports to >" L6"  reports to > "L7"  reports to > "L8"

Depending on role, it will show the data.For ex: If an AVP logs in, then he will see the project details which are part of his domain.Similarly  if a VP logs in then he will see the all the AVPs under him and their project details.Similarly if a person from "L6" logs in then he will see all the VPS,AVPs and their project details , It will continue till L8.

So data is getting restricted as per their role.How to achieve in Power BI?

[v-yangliu-msft]

Hi  @saktisahoo2006 ,

You might consider using Power BI RLS.

This is the related document, you can view this content:

https://www.biconnector.com/blog/power-bi-steps-to-setup-rls-row-level-security-static-and-dynamic/

https://medium.com/analytics-vidhya/power-bi-row-level-security-and-dynamic-rls-1ee7faaa703e

https://community.powerbi.com/t5/Desktop/RLS-multiple-combination/m-p/694197

https://community.powerbi.com/t5/Desktop/Dynamic-Row-level-security-for-multiple-column-values/m-p/6...

https://www.abylon.hu/blog/multi-level-access-rights-in-dynamic-row-level-security/

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[saktisahoo2006]

Please provide some idea like how to achieve this scenario.