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

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.