Forum Discussion

GilbertQ's avatar
GilbertQ
Super User
8 years ago
Hi there

I would suggest splitting the data into multiple rows. In doing it in this way it will easily work using RLS
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

 

Thanks for reply.

 

I have three roles for example RoleA,RoleB,RoleC.

 

Under RoleA there are 2000 Users.

 

Under RoleB there are 10,000 Users.

 

And Under RoleC there are 15,000 Users.

 

So if I split the data it will be the tedious process Right.

 

Is there any other way to handle Comma seperated data.

 

Thank You.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Anonymous,

     

    In fact, even if you achieve dynamic RLS based on username, you still need to assign roles to users.

     

    AFAIK, current power bi not support contains batch methods. so I'd like to suggest you submit an idea for add powershell support to assign roles.

    Regards,
    Xiaoxin Sheng