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 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?

Need Help

2 Replies

  • 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