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.

  • sivarajan21's avatar
    sivarajan21
    Post Prodigy
    2 years ago

    Hi marcorusso ,

     

    Thanks for your quick response!

    I have run the Dax studio to find the what is causing the issue and found this server timings.

     

    But I am unable to figure out exactly where the problem is and what remedy should be taken.

    please advise me on this?

     

    Thanks in advance!

    marcorusso