Send RLS Server Side to limit data coming back

[Don-Bot]

Is there a way to send the RLS FIlter to the server to limit the data that is sent back?

I am currently using DirectQuery with Databricks.  However, the RLS seems to be filtering in Power BI and not on the server.  Which is extremely inefficient.

Is there a way to add the RLS filter to what is sent to the server so only the data that should be sent to the client is sent?

[lbendlin · Accepted solution]

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

See if you can use that to send the USERPRINCIPALNAME back to Databricks.

[lbendlin · Accepted solution]

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

See if you can use that to send the USERPRINCIPALNAME back to Databricks.

[Don-Bot]

Thanks I'm looking into that now.  

I have another question (let me know if I need to post this as a separate discussion).

Do you have any idea why the execution time of the query power bi is sending back to databricks takes 1.5 seconds on databricks to execute but 17 seconds in power bi to finish the entire visual?

[lbendlin]

Use the Performance Analyzer in Power BI to investigate the timing for each visual. May just be a case of too many visuals on the page.

[Don-Bot]

I reduced it to 1 visual with my filters...

In Power BI Desktop it takes 62 seconds to render...

In Dax Studio 2 seconds

I copy the dax from the above and run it in Dax Studio connected to the same data model

[lbendlin · Accepted solution]

It spends all its time on the folded query.  In DAX Studio make sure to clear the cache before each run.