Forum Discussion
Create security role automatically
Hi Anonymous ,
Add another email address column for the office owner in the table, and then use the username() function for dynamic row level security, as described in a similar blog below.https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
There is not really anyway of automating role creation in Power BI Desktop at the moment. However it may not be necessary - if you google for "Dynamic Row Level Security" you will find lots of articles and videos about how you can create one role which can filter your model differently for every user. (I'm guessing that the reason you are getting a figure as high as 500 roles is that you have 500 users)
Thank you for the answer.
I have 500 offices and only office holders have to see their data.
Office holders or area managers (seen as holders of multiple offices) are into domain groups.
Hi Anonymous ,
Add another email address column for the office owner in the table, and then use the username() function for dynamic row level security, as described in a similar blog below.https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.