Dynamic Row-Level Security (RLS) in Power BI Without Creating Roles

I would like to propose a feature enhancement for Power BI that allows for the implementation of Row-Level Security (RLS) without the need to create roles. Currently, RLS in Power BI requires the creation of roles and defining rules to restrict data access. While this approach works well, it can become cumbersome and complex, especially in scenarios with a large number of users and dynamic security requirements.

Proposed Solution: I propose introducing a dynamic RLS feature that leverages user-specific attributes, such as email addresses or user IDs, to filter data without the need to create predefined roles. This could be achieved by using DAX functions like USERPRINCIPALNAME() to dynamically filter data based on the logged-in user.

Benefits:

Simplifies the process of implementing RLS, especially in large organizations.
Reduces the administrative overhead of managing multiple roles.
Enhances flexibility and scalability in managing data security.
Provides a more intuitive and user-friendly approach to data security in Power BI.
Use Case: For example, a sales dashboard could dynamically filter sales data to show only the relevant data for the logged-in salesperson without the need to create individual roles for each salesperson.

I believe this feature would greatly enhance the usability and flexibility of Power BI, making it easier for users to implement and manage data security.

Thank you for considering this idea. I look forward to the community's feedback and support.