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

This kind of analysis usually requires access to the live model (and dedicated quality time - not something we can do on a public forum). The VPAX file can be analyzed by tools such as www.daxoptimizer.com, but that service currently don't analyze the impact of RLS, so it would not be directly useful for that.

  • sivarajan21's avatar
    sivarajan21
    Post Prodigy
    2 years ago

    Hi marcorusso 

     

    Thanks for your quick response and your patience towards answering my questions!

    Me and my team will enroll in your course and learn these things😊

    I will close this query and accept your solution

    Just to confirm,Is dax optimizer a free source ?

     

    Thanks!

    • marcorusso's avatar
      marcorusso
      Most Valuable Professional
      2 years ago

      DAX Optimizer is a commercial product. It is now at a discount because it is in beta. However, you can save time and money for your model because the issues that DAX Optimizer would find are unimportant and unrelated to the performance issue you are experiencing.

      • sivarajan21's avatar
        sivarajan21
        Post Prodigy
        2 years ago

        Hi marcorusso 

         

        Thanks for the genuine and quick response!

        Please let me know if you need anything from my side in future and am happy to help!😊

         

        Thanks