https://community.fabric.microsoft.com/t5/Report-Server/Check-logged-user/m-p/1572393#M17277 <P><SPAN>How do I check if the user who logged in to power BI is present in the table that he creates and whether or not he has access to Power BI data?</SPAN></P> Mon, 28 Dec 2020 18:32:27 GMT mtzzwr 2020-12-28T18:32:27Z https://community.fabric.microsoft.com/t5/Report-Server/Check-logged-user/m-p/1572393#M17277 <P><SPAN>How do I check if the user who logged in to power BI is present in the table that he creates and whether or not he has access to Power BI data?</SPAN></P> Mon, 28 Dec 2020 18:32:27 GMT https://community.fabric.microsoft.com/t5/Report-Server/Check-logged-user/m-p/1572393#M17277 mtzzwr 2020-12-28T18:32:27Z https://community.fabric.microsoft.com/t5/Report-Server/Check-logged-user/m-p/1572402#M17278 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="277713" data-lia-user-login="mtzzwr" class="lia-mention lia-mention-user">mtzzwr</a>&nbsp;- Sorry, not quite understanding this. You can use USERPRINCIPALNAME function to get the identity of the user.&nbsp;<A href="https://docs.microsoft.com/en-us/dax/userprincipalname-function-dax" target="_blank">USERPRINCIPALNAME function (DAX) - DAX | Microsoft Docs</A></P> <P>&nbsp;</P> <P>Not quite understanding things beyond that in terms of what you are trying to do.</P> Mon, 28 Dec 2020 18:37:21 GMT https://community.fabric.microsoft.com/t5/Report-Server/Check-logged-user/m-p/1572402#M17278 Greg_Deckler 2020-12-28T18:37:21Z https://community.fabric.microsoft.com/t5/Report-Server/Check-logged-user/m-p/1572406#M17279 <P><SPAN>can I define a condition to only perform a certain function if my table has the user who is logged in?</SPAN></P> Mon, 28 Dec 2020 18:40:45 GMT https://community.fabric.microsoft.com/t5/Report-Server/Check-logged-user/m-p/1572406#M17279 mtzzwr 2020-12-28T18:40:45Z https://community.fabric.microsoft.com/t5/Report-Server/Check-logged-user/m-p/1576869#M17321 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="277713" data-lia-user-login="mtzzwr" class="lia-mention lia-mention-user">mtzzwr</a>&nbsp;<BR />You would need to use USERPRINCIPALNAME to perform a dynamic RLS. Please refer to the below link:<BR /><A href="https://exceltown.com/en/tutorials/power-bi/powerbi-com-and-power-bi-desktop/dax-query-language-for-power-bi-and-power-pivot/userprincipalname-show-user-name-and-use-it-in-rls-dax-power-pivot-power-bi/" target="_blank" rel="noopener">USERPRINCIPALNAME – show user name and use it in RLS (DAX – Power Pivot, Power BI) – ExcelTown – kurzy přesně pro Vás</A></P> <P><BR />Remember Report Server is not same as Power bi Service:&nbsp;<A href="https://docs.microsoft.com/en-us/power-bi/report-server/row-level-security-report-server#add-members-to-roles" target="_blank">Row-level security (RLS) in Power BI Report Server - Power BI | Microsoft Docs</A></P> <P><BR />Paul Zheng _ Community Support Team<BR />If this post helps, please Accept it as the solution to help the other members find it more quickly.</P> Fri, 01 Jan 2021 02:25:38 GMT https://community.fabric.microsoft.com/t5/Report-Server/Check-logged-user/m-p/1576869#M17321 Anonymous 2021-01-01T02:25:38Z