Forum Discussion
Row level security with multiple roles
Hi everyone, I have a on prem tabular SSAS model that I use through the gateway. There are two group of users: Sales Managers are managers of salespersons. Dimension table is filtered so that t...
I'm facing the same issue - and the RLS documentation is NOT addressing the situation where a user belongs to multiple Security Roles - and we want to restrict on a specific Security Role.
Using Excel its possible to modify the ConnectionString to the Cube / Workspace adding a parameter for the preferred Security Role.
"Roles=Sales Managers" or "Roles= Product Managers".
How can this be achieved using Power BI published reports in the cloud? Where can the report designer choose what Security Role is intended to use a certain report variant?