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...
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