RLS is not working for a specific visual having column from KQL database.

[riddhi_onyxdata]

I am using tables from KQL database and lakehouse.I am creating a measure in which i am just taking the MAX() of the column from the table from KQL database.
In the table visual, 3 column are coming from the tables which is coming from lakehouse and rest 2 are the measures from KQL database.
I am using DAX query for RLS. For eg, If the domain of the emailid accessing the report is "abc.com" then all the data should be visible else data should be visible as per the id. 
It is throwing error with one specific visual. Also, when RLS is applied only then it is causing an issue, Otherwise report and visual is loading correctly.

[Anonymous · Accepted solution]

Hi @riddhi_onyxdata ,

This error indicates that your query appears to be overly complex and has reached its memory limit, resulting in a related error. I'm not sure what you did, but here's what I did:
From Power BI Desktop, I selected KQL Database and Lakehouse as the data source and created a connection, the connection mode is Import for both, then I did create an RLS role with DAX and tested this RLS role on both Desktop and Service, but neither of them had problems.
If the operation you performed is not the same as my test, please describe your steps in detail so that I can perform further relevant tests. If you are doing something similar to what I am doing, perhaps you can change the connection mode to Direct Query mode when connecting to KQL Database and Lakehouse, so that your query will be passed to the data source, and perhaps your query performance will be better this way.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Refactor your DAX query in DAX Studio.  Examine the query plan and eliminate the steps that create excessive number of records.