Debug semantic model (RLS)

[Peter_23]

Hi community, in this time I'm trying to find a tool for debug the SM.

I actually I use the SQL server profile with "EventClass" -> Query begin. this tool is useful to try to figure out, whats actually happen with user interaction,  so It's fine,  but the RLS rules is not showing me.

If you try test role with sql profiler, don't show rls rules, do show? 

is there another tool to see when the user login apply the RLS as traces? 

thanks in advance.

[Peter_23]

Ok @lbendlin , is there a tool (software) to debug RLS?

[lbendlin · Accepted solution]

I am not aware of any tool. Debugging RLS involves grabbing a non-workspace user for each of the roles and having them show you on their screen what they see .

[Peter_23]

Thanks @lbendlin  I hope in the future It'll have 

[lbendlin]

So you want to apply RLS without applying RLS... That means that in your Query you need to apply the filters that would be equivalent to the ones RLS imposes on the semantic model. 

There is no flag "This filter sponsored by RLS"  that I am aware of.