Forum Discussion
row level security - for many users
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
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