Forum Discussion
RLS when connecting to an existing Semantic Model
Hello all,
I am currently developing a dashboard based on an already existing Semantic Model in my organization. Basically we are connnecting to the model and developing some alternative measures and visuals. We are trying to restric access to our new dashboard through some row level security rules based on users emails by connecting a table to the model and using UserprincipleName() to filter access but it doesn't seem to be working.
Do we need to define this rules in the original dataset? Is it not possible to define new RLS rules over and existing dataset? Is there a workaround? We are aware of this "Treatas" option (https://radacad.com/row-level-security-on-a-directquery-to-power-bi-dataset-composite-model-my-findings) but we would prefer not to use it as it would imply a lot of modifications in our measures.
Thanks in advance
Yes, RLS should be set on a model-level so you need to do this in the original dataset. I would not do any workarounds if you can do it the normal way.
2 Replies
- Brunner_BI
Impactful Individual
Yes, RLS should be set on a model-level so you need to do this in the original dataset. I would not do any workarounds if you can do it the normal way.
- AnonymousNot applicable
Hi Anonymous ,
Whether the advice given by Brunner_BI has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.