Forum Discussion

ahmadov_10's avatar
ahmadov_10
Icon for Helper II rankHelper II
4 years ago
Solved

Sharing 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 ema...
  • Burningsuit's avatar
    4 years ago

    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