RLS to Admin Users

[abdul452]

Hi Everybody,

Below is my table.

1. I need help with setting RLS on the 'Company' column from the Company table, to populate respective 'Store' and 'StoreName' values.
2. The result from 1, to be shown only to 'IsAdmin' users and within that 'Company' from the UserAccess table.

Company Table - 

Company	Store	Store Name
151	2251	Target
152	3250	Lowes
151	2252	IFB
153	4250	Tyson
152	2250	HEB

UserAccess Table -

User	ActiveDirectoryID	Company	IsAdmin
1	421E-A7E5	151	1
2	4199-BA8B	152	1
3	8A27-47E3	153	1
4	3244-BA8B	151	0

Expected Result for Company '151' -

Company	Store	Store Name
151	2251	Target
151	2252	IFB

Expected Result for Company '152' -

Company	Store	Store Name
152	3250	Lowes
152	2250	HEB

Appreciate your help. Thanks. @v-yiruan-msft , @MathiasChd , @VahidDM , @daxer-almighty 

[VahidDM · Accepted solution]

Hi @abdul452 

Please see this link and complete the learning path.

https://docs.microsoft.com/en-us/learn/modules/row-level-security-power-bi/

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

Appreciate your Kudos🙏!!

[abdul452]

Thank you @VahidDM