Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

RLS when connecting to multiple datasets

Hi,   I've got 3 separate datasets all with RLS on the same table that exists in all datasets. I'm creating a new dataset that links all three datasets via directquery. It seems that the original R...
Need Help
v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi Anonymous ,

 

This is a limitation 

  • RLS rules will be applied on the source on which they're defined, but won't be applied to any other datasets in the model. RLS defined in the report won't be applied to remote sources, and RLS set on remote sources won't be applied to other data sources. Also, you can't define RLS on a table from another source group nor can you define RLS on a local table that has a relationship to another source group.

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks - but does this mean the original RLS should still stand? Because i'm finding that people can access data that they normally wouldnt be able to access, simply because its a directquery to the dataset rather than accessed via the dataset. I also had this problem when i put datasets into a dashboard. RLS is defined by the UserPrincipalName