How to carry RLS from original dataset to new model that tap on it

[husfghk11]

I have set RLS in dataset A and has allowed a viewer to rebuild the dataset. However, it seems like the RLS cannot be carried to the new composite model. Not sure if this is the case. If it is not, may I know which part that may have gone wrong? If it is, what can I do to make the RLS setting carry to all the reports and new dataset that tap on it? 

[v-zhangti · Accepted solution]

Hi, @husfghk11 

When you rebuild a dataset, the RLS settings are not automatically carried over to the new dataset. You will need to manually configure the RLS settings in the new dataset to ensure that the same security rules are applied.

To configure RLS in the new dataset, you can follow these steps:

1. Open the new dataset in Power BI Desktop.
2. Go to the "Modeling" tab and click on "Manage Roles".
3. Click on "Create" to create a new role.
4. In the "Table filter" section, select the table that you want to apply the RLS to.
5. In the "Filter type" section, select "Advanced filtering".
6. In the "Advanced filtering" section, enter the DAX expression that defines the RLS rules for the selected table.
7. Click "OK" to save the role.

Repeat these steps for each table that you want to apply RLS to in the new dataset. Once you have configured the RLS settings in the new dataset, you can use it in your composite model and the RLS rules will be applied to the data.

Note that if you have multiple datasets that use the same RLS rules, you can create a template dataset that contains the RLS settings and use it as a starting point for new datasets. This can help ensure consistency in the RLS settings across multiple datasets.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.