Different RLS scenario's for the same user in multiple reports based on the same dataset

Hi, JosKuiper 

You might consider leveraging composite models and dataset parameters for a more manageable solution.

While Power BI doesn't support using report names directly in RLS, you can emulate this behavior by using dataset parameters in conjunction with the Power BI service's ability to apply different parameter values for each dataset.

Or build a composite model that combines the original dataset with its parameterized version. This approach allows you to maintain a single source of truth while applying different RLS rules based on the parameter value, which acts as a proxy for the report name.

Define RLS rules to account for parameter values. For example, you can set a parameter that toggles between the HR and Illness scenarios, and use this parameter in a DAX expression to dynamically change the RLS filter.

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.