cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
varundevaraj Frequent Visitor
Frequent Visitor

Row level security - Parent and Child level from same table.

I need to create Row Level security based on 2 criteria.

1. Account NBR
2. Business Code.
These two fields are available in the same table in the same field based on the code type. If code type = Account then Code value has Account NUmber and if code type is Business then Code value has Business Code. And this is the table I need to use for implementing security.
Code type Code value username
ACCTNBR 123 a
Business XYZ b
 
The relation between account number and Business
Acct nbr business code
123 xyz
123 abc

Now I have two scenarios
1. Some users who can see the whole account from the above example the user "a" can see everything related to 123. ie "xyz" and "abc"
2. Some users who can see only see particular business codes that they work on. ex: user b can only see "xyz"
 
Any Suggestions?
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Row level security - Parent and Child level from same table.

Hi @varundevaraj ,

From your description, you could refer to below links to have a try:

http://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi

http://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi

If it still could not help you, could you please offer your pbix file to have a test if possible?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Row level security - Parent and Child level from same table.

Hi @varundevaraj ,

From your description, you could refer to below links to have a try:

http://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi

http://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi

If it still could not help you, could you please offer your pbix file to have a test if possible?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Row level security - Parent and Child level from same table.

Hi @varundevaraj ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.