Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 group of 100 users and 3 level hierarchy of access rights (country level > division level > team level)
So far, I have created some roles manualy (just for testing), but I need some solution applicable to larger user groups and easily managable.
So I'm looking for some way how to connect security to some sort of datasource, which would contain information about access rights.
Thank you,
Zuzana
Solved! Go to Solution.
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
Hi @Anonymous
Would your users be part of an Active Directory Group?
Hi @GilbertQ
yes, they are in active directory. The information about country/division/team is held in internal app, so there may be posibility to get this to active directory, but I'm not sure how can PBI Service work with this..
Thanks,
Zuzana
Hi @Anonymous
If you could get it from your External App that would be best, but it would need to map to the UPN (User Principal Name) in Azure.
There is a connector to Active Directory in Power BI Desktop.
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
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
Hi,
I think you should create only 3 user groups (i.e. country level > division level > team level) in power BI desktop and then you can add multiple users under security (datasets) in power BI service.
Can we make this user adding part dynamic?