topic Re: dax on role manager ssas? in DAX Commands and Tips

dax on role manager ssas?

Anonymous — Tue, 11 Jan 2022 14:01:27 GMT

I am puzzled about the Role Manager in Visual Studio when working with SSAS tabular cubes:

Is my understanding correct?

When a user logs to the cube, the “security” will check each role and see if the user is in that role… if the user is in the role; it gives the said access.

If the user is in multiple roles, it will give some sort of UNION between all of them, so the user can see as much as possible , correct?

Is this documented anywhere?

Ps: is there also documentation in cases where you force less access (like having a ‘users’ table and putting that filter in a .pbix only on a specific page?

Re: dax on role manager ssas?

v-chenwuz-msft — Fri, 14 Jan 2022 02:30:02 GMT

Hi Anonymous ,

Answer for short, yes, the user will have all the access of each role that contains him.

The process is that the user connect the data model, the user gets a list of permissions after reading all the role in this model. Then the user queries the data via this permissions list.

For more detail, please refer this article.

Roles and Permissions (Analysis Services) | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.