Role creation for RLS in Power BI

[Marico]

I have 10 roles for RLS and I need to have these in 10 reports. Do I have to manually create all 10 roles in each of the report or is there anyway to automate this process?

[Anonymous]

Hi  @Marico ,

If there are many data sets, you can’t, if there is only one data set, you can create 1 report in the workspace, and then copy each report to generate 10 reports. Because the role is created in the power bi desktop and published to the power bi service, we add users to the ten roles in the data set.

Best Regards,

Liu Yang

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

[Greg_Deckler]

@Marico Well, if you used import mode for each of those 10 reports then yes. However, if you created a single dataset and then used Live connection mode to that dataset to create each of the 10 reports then you would only have to do it once.