Yes, it is possible to add multiple members to a role in one go using Power BI Service. You can do this by using a CSV file that contains a list of email addresses for the members you want to add to the role.
To add members using a CSV file, go to the Power BI Service, click on the "Settings" (gear) icon, then select "Security" and "Manage roles". Select the role you want to add members to, click on "Members", and then select "Bulk add".
You can then upload a CSV file that contains a list of email addresses for the members you want to add to the role. Each email address should be on a separate line. Once you upload the file, the members will be added to the role automatically.
Another option is to use dynamic row-level security (DRLS) instead of adding members to a role. With DRLS, you can define rules that automatically filter data based on the user's email address or other attributes. This can be more efficient than managing a list of members manually, and it allows for more flexibility in defining access control rules.
To use DRLS, you'll need to define a table that contains the email addresses and other attributes that you want to use for filtering data. You can then define rules that use these attributes to filter data dynamically based on the user who is accessing the report.
