Roles - copy paste

[AnetaK]

Hello,

I have a report with around 100 RLS roles.

My task is to recreate them in a new report.

Is there a way to copy them?

[AnetaK]

@timg thank you for the answer.

Unfortunatelly there is a complicated RLS mechanism implemented.

[timg]

Hi Aneta,

As far as I'm aware there is no direct copy paste method. What you could try is:

• Make a template file with the roles included and use that file for any future reprots that require RLS (unfortunately means you do have to redo the 100 roles once)
• use dynamic RLS. This way you only have to make 1 role, though you would have to do some more work in order to get this set up (example: What Do You Need to Implement Dynamic Row-Level Security in Power BI? - RADACAD)

Regards,

Tim