Forum Discussion
Helper IISharing RLS applied on dataset_YYY (report 1) to Report 2 connected to dataset_YYY
Hello Experts ,
I have a report published from desktop to service when I defined before 3 Roles in desktop and it works fine in service (throught dataset_YYY security properties , i added the emails and i test the roles , it's OK) .
But I ask , how to apply these roles to the Report 2 that is connected to dataset_YYY and this report contain the analysis visuals ?
It is possible any solution to share Roles RLS from principal report 1 to other report 2 ?
( @amitchandak , @selimovd , @parry2k , @Greg_Deckler , @arvindsingh802 , @arvindsingh802 , @Pragati11 and all community of super stars , i need your helps , Thanks)
Hi ahmadov_10
Row Level Security (RLS) is set on the Dataset, and affects any Report that uses that Dataset. That means that your Report1 on dataset_YYY will be subject to the RLS security that is on dataset_YYY, but also Report2 (and 3 and 4) that access dataset_YYY will also be subject to RLS. Indeed any other data access - via Excel for example will also be subject to RLS. This is because the security is applied at the Dataset level and anything accessing that Dataset is subject to RLS. One quirk of Power BI is that you can only test RLS against the first Report defined on the Dataset, but all other reports on the dataset are subject to RLS.
Hope this helps
Stuart
2 Replies
- Burningsuit
Resident Rockstar
Hi ahmadov_10
Row Level Security (RLS) is set on the Dataset, and affects any Report that uses that Dataset. That means that your Report1 on dataset_YYY will be subject to the RLS security that is on dataset_YYY, but also Report2 (and 3 and 4) that access dataset_YYY will also be subject to RLS. Indeed any other data access - via Excel for example will also be subject to RLS. This is because the security is applied at the Dataset level and anything accessing that Dataset is subject to RLS. One quirk of Power BI is that you can only test RLS against the first Report defined on the Dataset, but all other reports on the dataset are subject to RLS.
Hope this helps
Stuart
ahmadov_10I confirmed that RLS are applied in the dataset_YYYY of report 1 and after when we use a reports 2 or 3 that used the data of dataset_YYYY : RLS are automatically applied.