Forum Discussion
Connecting to powerbi dataset with existing RLS
Hello, I am stuck in a scenario that I hope someone with more knowledge can help. I have created a powerbi dataset file (this only has roles, there is no facttable here) with dynamic RLS and ...
When you link the dataset data models you need to make sure that the link goes ONLY from Set1 to Set2. Any bidirectional connection will negate the RLS.
There are also unintended side effects when you give users access to your Set2 dataset that have access to Set1 but are not member of any roles.