Forum Discussion
tarunbisht20001
1 year agoFrequent Visitor
Need help with setting up Dynamic RLS on Hierarchy Data
I have a table RLS it have two columns email and project ID now i have setup a role on table RLS as [Email] = USERPRINCIPALNAME() now i have a project table which is the main table in schema w...
PijushRoy
1 year agoCommunity Champion
Hi tarunbisht20001
Please follow the video step by step video https://www.youtube.com/watch?v=61fUUciDnks
Example which I did a few months back
Then created Role
Go to Report security in Power BI service and assign users email ID or Users Group
Please let me know if not solved
tarunbisht20001
1 year agoFrequent Visitor
Hi PijushRoy,
In my case i cant keep path column in the same table where user data exist(User Email).
- PijushRoy1 year agoCommunity Champion
What is the reason tarunbisht20001
Please create and share sample PBIX file Google Drive link