topic Re: RLS to Admin Users in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/RLS-to-Admin-Users/m-p/2086592#M47448 <P>Thank you&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="315278" data-lia-user-login="VahidDM" class="lia-mention lia-mention-user">VahidDM</a>&nbsp;</P> Mon, 20 Sep 2021 15:09:44 GMT Anonymous 2021-09-20T15:09:44Z RLS to Admin Users https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/RLS-to-Admin-Users/m-p/2084806#M47383 <P>Hi Everybody,</P><P>Below is my table.</P><OL><LI>I need help with setting RLS on the 'Company' column from the Company table, to populate respective 'Store' and 'StoreName' values.</LI><LI>The result from 1, to be shown only to 'IsAdmin' users and within that 'Company' from the UserAccess table.</LI></OL><P>&nbsp;</P><P>Company Table -&nbsp;</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Company&nbsp;</TD><TD>Store</TD><TD>Store Name</TD></TR><TR><TD>151</TD><TD>2251</TD><TD>Target</TD></TR><TR><TD>152</TD><TD>3250</TD><TD>Lowes</TD></TR><TR><TD>151</TD><TD>2252</TD><TD>IFB</TD></TR><TR><TD>153</TD><TD>4250</TD><TD>Tyson</TD></TR><TR><TD>152</TD><TD>2250</TD><TD>HEB</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>UserAccess Table -</P><TABLE border="1"><TBODY><TR><TD>User</TD><TD>ActiveDirectoryID</TD><TD>Company</TD><TD>IsAdmin</TD></TR><TR><TD><STRONG>1</STRONG></TD><TD><STRONG>421E-A7E5</STRONG></TD><TD><STRONG>151</STRONG></TD><TD><STRONG>1</STRONG></TD></TR><TR><TD>2</TD><TD>4199-BA8B</TD><TD>152</TD><TD>1</TD></TR><TR><TD>3</TD><TD>8A27-47E3</TD><TD>153</TD><TD>1</TD></TR><TR><TD>4</TD><TD>3244-BA8B</TD><TD>151</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expected Result for Company '151' -</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Company&nbsp;</TD><TD>Store</TD><TD>Store Name</TD></TR><TR><TD>151</TD><TD>2251</TD><TD>Target</TD></TR><TR><TD>151</TD><TD>2252</TD><TD>IFB</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expected Result for Company '152' -</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Company&nbsp;</TD><TD>Store</TD><TD>Store Name</TD></TR><TR><TD>152</TD><TD>3250</TD><TD>Lowes</TD></TR><TR><TD>152</TD><TD>2250</TD><TD>HEB</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Appreciate your help. Thanks. Anonymous</a>&nbsp;,&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="304024" data-lia-user-login="MathiasChd" class="lia-mention lia-mention-user">MathiasChd</a>&nbsp;,&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="315278" data-lia-user-login="VahidDM" class="lia-mention lia-mention-user">VahidDM</a>&nbsp;,&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="255913" data-lia-user-login="daxer-almighty" class="lia-mention lia-mention-user">daxer-almighty</a>&nbsp;</P> Mon, 20 Sep 2021 01:07:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/RLS-to-Admin-Users/m-p/2084806#M47383 Anonymous 2021-09-20T01:07:40Z Re: RLS to Admin Users https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/RLS-to-Admin-Users/m-p/2086183#M47427 <P>Hi&nbsp;Anonymous</a>&nbsp;</P><P>&nbsp;</P><P>Please see this link and complete the learning path.</P><P>&nbsp;</P><P><A href="https://docs.microsoft.com/en-us/learn/modules/row-level-security-power-bi/" target="_blank">https://docs.microsoft.com/en-us/learn/modules/row-level-security-power-bi/</A></P><P>&nbsp;</P><P><FONT face="helvetica"><SPAN>If this post&nbsp;</SPAN><STRONG>helps</STRONG><SPAN>, please consider&nbsp;<STRONG>accepting</STRONG></SPAN><STRONG><EM>&nbsp;it as the solution<SPAN>&nbsp;</SPAN></EM></STRONG><SPAN>to help the other members find it more quickly.</SPAN></FONT></P><P><FONT face="helvetica"><SPAN><STRONG>Appreciate your Kudos</STRONG></SPAN></FONT><span class="lia-unicode-emoji" title=":folded_hands:">🙏</span>!!</P> Mon, 20 Sep 2021 11:42:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/RLS-to-Admin-Users/m-p/2086183#M47427 VahidDM 2021-09-20T11:42:40Z Re: RLS to Admin Users https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/RLS-to-Admin-Users/m-p/2086592#M47448 <P>Thank you&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="315278" data-lia-user-login="VahidDM" class="lia-mention lia-mention-user">VahidDM</a>&nbsp;</P> Mon, 20 Sep 2021 15:09:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/RLS-to-Admin-Users/m-p/2086592#M47448 Anonymous 2021-09-20T15:09:44Z