Forum Discussion
The report cannot be viewed because the underlying dataset uses row level security
Hi svp1000
will i need to give access to 7000 users individually if there is no active directory that exists for this group?
Yes, you will need to do this if you do not use groups. You should use groups.
You can use the following groups to set up row-level security.
- Distribution Group
- Mail-enabled Group
- Microsoft Entra Security Group
Here is more information:
https://guyinacube.com/2020/02/25/can-you-use-groups-with-power-bi-row-level-security-rls/
Hi, svp1000
Thanks for the reply from djurecic , please allow me to provide addition:
You can also try optimizing RLS, RLS filters can affect query performance, so it's critical to design your model efficiently.
Apply RLS filters primarily to dimension-type tables, which are typically small and contain attributes such as user, department, or region. Fact-type tables, which contain transactional data, should have fewer RLS filters.
Make sure your relationship is well-designed, as RLS filters spread through relationships. Follow the principles of star schema and maintain clear relationships between tables.
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.