Forum Discussion
question Row Leve Security and multiple reports.
Hi Anonymous
If you want to apply one RLS to multiple reports, you can consider to use SSAS as a data souce and set the RLS in SSAS,then use live connection to connect to the data source, then the RLS you set in SSAS can work and you don't need to create multi RLS, it different from the RLS created in Power BI Desktop, if you want to edit or modify the RLS, you need to edit in SSAS, you can refer to the following link.
Dynamic row-level security with Analysis services tabular model - Power BI | Microsoft Learn
Row Level Security with SSAS Tabular Live Connection in Power BI - RADACAD
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super Userhello Anonymous ,
the thing is that each row level security is defined in each report to each dataset, so it should be done separately per dataset.
If I am using a common dataset for all three reports, how would it work?