Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi everyone,
I have a on prem tabular SSAS model that I use through the gateway. There are two group of users:
Both these group of users have their own Power BI Dashaboard/Reports, security take hand of filtering the data to their field of interest.
The big question: How can this be solved if one user have both of these groups?
I was thinking I need some way of telling from the Power BI online report that the user is in this "role" now.
First thought was assigning SSAS roles in the connectionstring when creating report in Power BI Desktop. but it doesnt seem to work throught the Enterprise Gateway when published.
The alternative would be to have two models, each with its own security scheme activated.
Any thouhgts?
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?
First thought was assigning SSAS roles in the connectionstring when creating report in Power BI Desktop. but it doesnt seem to work throught the Enterprise Gateway when published.
We can use the role which design on tabular model, here is a document which describe this, please refer to the link below.
https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-row-level-security-onprem-ssas-tabular
Regards,
Charlie Liao