Forum Discussion

Don-Bot's avatar
Don-Bot
Helper V
2 years ago

Row Level Security (RLS) Causing 1,000,000 record error when in use

I found this post that is similar to my issue:  https://community.fabric.microsoft.com/t5/Issues/1000000-row-limit-error-when-viewing-report-using-RLS-Row-Level/idi-p/459081 I have a rather large ...
Need Help
rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

Hi Don-Bot  - When using Row-Level Security (RLS) in Power BI with a large semantic model and a detailed fact table, encountering performance issues or errors like "a million record error"

This is due to the additional filters and complexity that RLS introduces.

you can check on optimize the filters ID = int(userprincipalname)

Since the issue does not occur without RLS, compare the performance of queries with and without RLS. This can help identify specific elements of the RLS logic causing performance issues.

[ID] IN (
SELECT [ID]
FROM [Users]
WHERE [Email] = USERPRINCIPALNAME()
)

 

check the all other criterias like model optimization, cardinality check.

 

 

 

  • Clampazzo's avatar
    Clampazzo
    Resolver I
    2 years ago

    Hi rajendraongole1 , stupid question for you,

     

    How do I check the performance of my RLS queries?  Especially since they error out and I can't get the dax from them to use in dax studio?

    Also, what is the query/measure you posted meant for?