https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-level-security-get-AD-attribute-dynamically/m-p/2773154#M86408 <P>Hi,</P><P>I have the following issue related to RLS. Is there any similar way to dynamically call e.g. AD attribute of signed user as I would use regular USEPRINCIPALNAME() in RLS role? How can I utilize the user's AD attributes dynamically after she/he has signed in to Power BI service?</P><P>&nbsp;</P><P>I need to filter data using a location information. For a user who sings in to Power BI service, has this location information as an attribute in AD. I need to filter student data based on signed teacher (user) and I need to make sure that the teacher sees only her/his students data.&nbsp;</P><P>&nbsp;</P><P>However, I cannot import any AD related data to Power BI dataset and I cannot use AD connector to make a direct query based on the signed user.</P> Fri, 16 Sep 2022 10:16:31 GMT BL_consultant 2022-09-16T10:16:31Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-level-security-get-AD-attribute-dynamically/m-p/2773154#M86408 <P>Hi,</P><P>I have the following issue related to RLS. Is there any similar way to dynamically call e.g. AD attribute of signed user as I would use regular USEPRINCIPALNAME() in RLS role? How can I utilize the user's AD attributes dynamically after she/he has signed in to Power BI service?</P><P>&nbsp;</P><P>I need to filter data using a location information. For a user who sings in to Power BI service, has this location information as an attribute in AD. I need to filter student data based on signed teacher (user) and I need to make sure that the teacher sees only her/his students data.&nbsp;</P><P>&nbsp;</P><P>However, I cannot import any AD related data to Power BI dataset and I cannot use AD connector to make a direct query based on the signed user.</P> Fri, 16 Sep 2022 10:16:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-level-security-get-AD-attribute-dynamically/m-p/2773154#M86408 BL_consultant 2022-09-16T10:16:31Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-level-security-get-AD-attribute-dynamically/m-p/2775373#M86627 <P>In my experience the AD connector is excruciatingly slow. You may want to ask your AD people if they provide regular (eg daily) extracts in easy to consume format,&nbsp; and use that extract instead for your RLS.</P> Sat, 17 Sep 2022 19:54:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-level-security-get-AD-attribute-dynamically/m-p/2775373#M86627 lbendlin 2022-09-17T19:54:52Z