Gilbert Quevauvilliers performs a test:
I have been doing a fair amount of work on Row Level Security (RLS) where the requirements were quite complex to implement.
Once I had completed the implementation of RLS there were two outstanding items I needed to test.
- Make sure that the users are only viewing the data they should see.
- Ensure that the performance of a selected user is still as fast as possible.
I would like to mention that this certainly can be done using DAX studio to get the query performance stats, I wanted to test this using Excel.
Gilbert had to do a fair amount here, but there’s a nice walkthrough indicating how to do it all.