Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hi
I have a on-Prem Power BI report server where I upload pbix dashboards to. I am using row level security on a number of dashboards where i have defined groups that I manually assign users to. I would like to be able to assign users dynamically using REST APIs like Add Group User (https://docs.microsoft.com/en-us/rest/api/power-bi/groups/add-group-user)
I was wondering if this is possible on a on premise report server where we upload the pbix files to?
Will it only work for Power BI premium (Service) where I define workspaces, datasets and reports?
Is there any way to achieve this using APIs or via code?
Thanks
Jim
Solved! Go to Solution.
Outsource this to AD. In your RLS roles specify AD groups, not users. Then maintain group membership in your AD management tool.
Outsource this to AD. In your RLS roles specify AD groups, not users. Then maintain group membership in your AD management tool.
User | Count |
---|---|
13 | |
3 | |
2 | |
2 | |
2 |