Forum Discussion

Gianca's avatar
Gianca
Frequent Visitor
4 years ago
Solved

RLS in composite mode

Hi,   I'm tring to set up the RLS in composite model, but seem not working correctly.   I'm also using a Gateway to connect on-prem data.   At first i did a test creating a DataSet and a Report...
Data Protection
Gianca's avatar
Gianca
Frequent Visitor
4 years ago

Hi,

           I've found the solution and the problem wasn't strictly related to the RLS, but to the composite model.

 

In the composite Model you have the shared dataset + the report dataset

 

You need to define security as follow:

 

Shared Dataset  as  Viewer+Build

 

Report dataset as Viewer

 

 

Here the article that helped me:

 

https://www.sqlbi.com/blog/marco/2021/06/03/setting-the-right-permissions-for-users-of-composite-models/

 

Thanks

 

Giancarlo