Forum Discussion

sivarajan21's avatar
sivarajan21
Post Prodigy
2 years ago
Solved

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
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • marcorusso's avatar
    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's avatar
marcorusso
Most Valuable Professional
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.