https://community.databricks.com/t5/data-engineering/power-bi-rls-running-extremely-slowly-with-databricks/m-p/68743#M33734 <P>Hi Everyone,<BR />I am brand new to databricks and am setting up my first Semantic Model with RLS and have run into an unexpected problem.</P><P>When I was testing my model with filters applied (where the RLS would handle later on) it runs extremely fast.&nbsp; I look in Query History and I can see the where statement for my filter being applied (which hits a partition) and returns information extremely quickly.&nbsp; Like in 2 seconds.&nbsp; We are using a serverless connection.<BR /><BR />However, when I setup my RLS in Power BI and then click "view as" and look at the exact same information it takes 12-30 seconds to return.&nbsp; I go into query history and the queries power bi is sending for RLS are so long that databrikcs doesn't show me the end where the where statemet should be (and the RLS filter).&nbsp;&nbsp;<BR /><BR />I'm assuming RLS isn't being applied on the server level.&nbsp;&nbsp;</P><P>Can someone tell me what is going on?&nbsp; PBI documentation states that it appends a where statement when it sends the statement on.&nbsp; But this doesn't appear to be happening.&nbsp; Is this a bug?&nbsp; Or do I need to do something special?</P> Fri, 10 May 2024 14:09:56 GMT Clampazzo 2024-05-10T14:09:56Z https://community.databricks.com/t5/data-engineering/power-bi-rls-running-extremely-slowly-with-databricks/m-p/68743#M33734 <P>Hi Everyone,<BR />I am brand new to databricks and am setting up my first Semantic Model with RLS and have run into an unexpected problem.</P><P>When I was testing my model with filters applied (where the RLS would handle later on) it runs extremely fast.&nbsp; I look in Query History and I can see the where statement for my filter being applied (which hits a partition) and returns information extremely quickly.&nbsp; Like in 2 seconds.&nbsp; We are using a serverless connection.<BR /><BR />However, when I setup my RLS in Power BI and then click "view as" and look at the exact same information it takes 12-30 seconds to return.&nbsp; I go into query history and the queries power bi is sending for RLS are so long that databrikcs doesn't show me the end where the where statemet should be (and the RLS filter).&nbsp;&nbsp;<BR /><BR />I'm assuming RLS isn't being applied on the server level.&nbsp;&nbsp;</P><P>Can someone tell me what is going on?&nbsp; PBI documentation states that it appends a where statement when it sends the statement on.&nbsp; But this doesn't appear to be happening.&nbsp; Is this a bug?&nbsp; Or do I need to do something special?</P> Fri, 10 May 2024 14:09:56 GMT https://community.databricks.com/t5/data-engineering/power-bi-rls-running-extremely-slowly-with-databricks/m-p/68743#M33734 Clampazzo 2024-05-10T14:09:56Z https://community.databricks.com/t5/data-engineering/power-bi-rls-running-extremely-slowly-with-databricks/m-p/68755#M33737 <P>My main question as it seems Power BI doesn't send RLS to azure databricks for filtering.&nbsp; Does anyone know how I can enable this or find a workaround?</P> Fri, 10 May 2024 16:02:26 GMT https://community.databricks.com/t5/data-engineering/power-bi-rls-running-extremely-slowly-with-databricks/m-p/68755#M33737 Clampazzo 2024-05-10T16:02:26Z https://community.databricks.com/t5/data-engineering/power-bi-rls-running-extremely-slowly-with-databricks/m-p/68756#M33738 <P>Are you trying to use <A href="https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security#using-the-username-or-userprincipalname-dax-function" target="_self">Power BI RLS rules</A> on top of DirectQuery?</P> <P>Can you give an example of the rules you're trying to apply? Are they static roles, or dynamic roles based on the user's UPN/email being in the dataset?</P> Fri, 10 May 2024 16:15:38 GMT https://community.databricks.com/t5/data-engineering/power-bi-rls-running-extremely-slowly-with-databricks/m-p/68756#M33738 KTheJoker 2024-05-10T16:15:38Z https://community.databricks.com/t5/data-engineering/power-bi-rls-running-extremely-slowly-with-databricks/m-p/68761#M33740 <P>I'm using an apps own data embedded solution for my setup.&nbsp; However, to answer your question, yes I am.<BR /><BR />My RLS is quite simple.&nbsp;&nbsp;</P><DIV><DIV><SPAN>[USER_ID]=</SPAN><SPAN>int</SPAN><SPAN>(</SPAN><SPAN>UserPrincipalName</SPAN><SPAN>())</SPAN></DIV></DIV><P><BR /><BR /></P> Fri, 10 May 2024 17:03:20 GMT https://community.databricks.com/t5/data-engineering/power-bi-rls-running-extremely-slowly-with-databricks/m-p/68761#M33740 Clampazzo 2024-05-10T17:03:20Z