RLS when connecting to multiple datasets

[Anonymous]

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 RLS does not carry through, and users are able to view all data.

As its directquery, i cannot implement RLS on any of the tables in this new dataset. 

I tried creating a new table and linking that to the corresponding tables in the linked datasets. I could apply RLS to the new table, but again, it doesnt flow through. Even when users arent assigned to any role, they are able to view the data from the linked datasets. Any idea what can be done here?

[v-chenwuz-msft]

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]

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