How to track the RLS performance in embedded

Hi, We have Power BI embedded. We have been updating our RLS to use DAX, as opposed to relying on bi-directional relationships etc in our model to increase perofrmace. The performance while usin...

Data Protection

General Comment

marcorusso
2 years ago
You should not rely only on Performance Analyzer results, because you are not considering whether the storage engine cache is used or not in the two cases. You should analyze the performance with DAX Studio impersonating the user and the role required. THe right approach is a big "it depends" and there are many things to consider. Potentially, the M2M approach could be way faster, but - it depends!
There is an entire section on Optimizing DAX Video Course - SQLBI that describes how to analyze and optimize security.

marcorusso

Most Valuable Professional

2 years ago

The large materialization is likely to be responsible. A solution requires a deeper review of data model and requirements, I'm not able to quickly help here, sorry!