Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

row level security - for many users

Hi,   Is there a way to set up access rights for many users at once or authomatically? Im looking for some way how to manage access rights to big dataset, based on row level security. I have ...
Need Help
  • tringuyenminh92's avatar
    tringuyenminh92
    9 years ago

    Hi Anonymous,

     

    I got your situation and tried to describe it as Dynamic RLS (row level security) with Power BI This is just one approach to achieve what we are calling dynamic data permission, so please feel free to reference and apply.

     

    If this works for you please accept it as solution and also like to give KUDOS.

    Best regards
    Tri Nguyen

Anonymous's avatar
Anonymous
Not applicable
9 years ago

HI GilbertQ,

 

thanks to your suggestion I actually found kind of solution. Instead of creating roles for each access level, I'll create new table with information about each user rights and join it with my main table. This new table can have datasource in some datawarehouse, that contains my App's data, so it can by authomaticaly updated when values in App get changed.

 

I created just one role with Table filter DAX expression [userlogin] = USERPRINCIPALNAME() and so far it looks like it might work.

Although I still think I'll need to put all the employees into this one group manualy. This is one step I'm still corcerned of :-/

 

Thanks for your help,

Zuzana

tringuyenminh92's avatar
tringuyenminh92
Memorable Member
9 years ago

Hi Anonymous,

 

I got your situation and tried to describe it as Dynamic RLS (row level security) with Power BI This is just one approach to achieve what we are calling dynamic data permission, so please feel free to reference and apply.

 

If this works for you please accept it as solution and also like to give KUDOS.

Best regards
Tri Nguyen