Forum Discussion
RLS in composite mode
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:
Thanks
Giancarlo
Hi Gianca ,
It would be great if you could provide more details.
What is your data source? Which two connection modes are you using for your composite model?
Generally, this type of error occurs when users are using DirectQuery for Power BI datasets and Azure Analysis Services .
There are known limitations：
-
RLS rules will be applied on the source on which they are defined, but will not be applied to any other datasets in the model. RLS defined in the report will not be applied to remote sources, and RLS set on remote sources will not be applied to other data sources. Also, you cannot 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.
-
KPIs, row level security, and translations will not be imported from the source in this preview release.
-
Users need 'Build' permissions on all datasets in the chain to access a report that leverages this feature.
For more，you can see：Considerations and limitations
Best Regards,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.