How to List all roles and their members (users/groups) of an Azure Analysis Services tabular model/database

by Victor_Sosa   Last Updated February 14, 2018 22:06 PM

I have a tabular model/database in an Azure Analysis Server instance. Model/database has roles and users/groups were added on each role. I can see the list by right click on the role and then go to membership.

My questions are:

1-Is there a script I can use to list the roles and the users in each role without using the method described? It can be using powershell, TMSL or any other ideas.

2-When you add a group as a role member, the group is displayed as a long hexadecimal string, is there a way to get the name of the group?

Related Questions

SQL Server AS: Set ImpersonationMode via PS

Updated June 19, 2015 23:02 PM

Problem with creating SSAS Roles using Powershell

Updated August 25, 2017 12:06 PM

Use Powershell to query SSAS connection string

Updated July 08, 2019 01:06 AM