Forum Discussion
RLS to Admin Users
Hi Everybody,
Below is my table.
- I need help with setting RLS on the 'Company' column from the Company table, to populate respective 'Store' and 'StoreName' values.
- 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. Anonymous , MathiasChd , VahidDM , daxer-almighty
Hi Anonymous
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🙏!!
2 Replies
- VahidDM
Super User
Hi Anonymous
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🙏!!
Thank you VahidDM