Forum Discussion
Passing user parameter from dashboard to SQL server through SSAS
Thanks for the reply malagari. However, in this case I will have to add each user individually to the role that is created. I actually want to get around that functionality as the user list is large and ever changing. Any thoughts?
I completely understand - I've worked on a project with similar constraints.
In my case, I was working with a client that used Office 365 as their main directory; I was able to create an Office 365 Group and assign it to the role, and then add users to the Office 365 Group when they needed access to Power BI. This still required bulk adding users to a group, but the management could be done by anyone with access to the Office 365 Portal. You may be able to do something similar if you're in an on-prem Active Directory as well.
Good luck - I'll follow this thread for other suggestions.