Forum Discussion
RLS DAX Query Optimization
Hi Team, I have implemented RLS on below model but the performance is slow. can some please suggest way to optimize DAX Code. RLS Tables: User Product Sub: A User can have access to atleast one...
Hi lbendlin - Thank you for your response. Adding ProductID to Fact requires us to reprocess all the fact data and it takes 2-3 days to reprocess historical data. As per existing design, we have relationship between Product and Customer Table. Product Table is small (130 rows) and Customer is large ( 9 Million rows).
Please suggest if there is way that i could optimize DAX query in RLS
Thanks,
Abhiram
Do the normalization in Power Query, or challenge the need for RLS in this scenario.